capabilities.work

CMS Query Drilldown

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

Recipe · 4 steps

CMS Query Drilldown

with SAP BI Tools

Submit a complex CMS query via POST and drill into the first result.

  1. Authenticate and capture the logon token.
  2. Submit the CMS query through the POST endpoint and capture the id of the first matching object.
  3. Retrieve the full metadata of the first matching object.
  4. List the children of the first matching object to explore its contents.
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 string (e.g. SELECT SI_ID, SI_NAME, SI_KIND FROM CI_INFOOBJECTS WHERE SI_KIND='Folder').
For your developer

Arazzo workflow sap-bi-tools:cms-query-drilldown, 4 operations: logon → executeCmsQueryPost → getInfoStoreObject → getInfoStoreChildren. Specs on APIs.io.

More recipes with SAP BI Tools

Create 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 ItemQuery and Schedule a DocumentRetire a Content Network Item