capabilities.work

Query and Schedule a Document

A 4-step recipe with SAP BI Tools. We can help you get access.

Recipe · 4 steps

Query and Schedule a Document

with SAP BI Tools · Analytics & BI Management

Find a document via CMS query and schedule it for immediate execution.

  1. Authenticate and capture the logon token.
  2. Run the CMS query to find candidate documents and capture the id of the first match.
  3. Schedule the first matched document for immediate execution in the requested output format.
  4. Read the newly created scheduled instance object back from the InfoStore to confirm it exists.
What you'll need to have ready
  • userName: The BI Platform username to authenticate with.
  • password: The password for the supplied user.
  • auth: The authentication type (secEnterprise, secLDAP, secWinAD).
  • query: The CMS query selecting documents to schedule (e.g. SELECT SI_ID, SI_NAME FROM CI_INFOOBJECTS WHERE SI_KIND='Webi').
  • format: The output format for the scheduled instance (e.g. pdf, xlsx).
For your developer

Arazzo workflow sap-bi-tools:query-and-schedule-document, 4 operations: logon → executeCmsQueryGet → scheduleDocumentNow → getInfoStoreObject. Specs on APIs.io.

More recipes with SAP BI Tools

CMS Query DrilldownCreate a SAC Team With a MemberExport Dimension Master DataExport Model Fact DataImport a Content Network ItemList and Inspect a SAC StoryLogon and Browse a FolderProvision a SAC UserPublish a Content Network ItemRetire a Content Network Item