Retrieve SI_DOCUMENTS for a Category via BIPRWS

[Former Member]

Is it possible to retrieve the equivalent of SI_DOCUMENTS for an InfoObject where SI_KIND = 'Category' via the RESTful Web Services SDK? In other words, list the documents hanging off a particular category?

Note: In my limited testing of BIPRWS using URL /biprws/infostore/<si_id>/ (where <si_id> = the SI_ID of the Category), the XML response (example below) is very watered down compared to what is available via Query Builder or the traditional Java SDK.

<?xml version="1.0" encoding="UTF-8"?>
<entry xmlns="http://www.w3.org/2005/Atom">
   <author>
      <name>username</name>
      <uri>http://biserver:6405/biprws/infostore/123456</uri>
   </author>
   <id>tag:sap.com,2010:bip-rs/AbcFHCNUZ7ZLieEoMfzOTeQ</id>
   <title type="text">Category Name</title>
   <updated>2016-06-16T03:54:19.851Z</updated>
   <link href="http://biserver:6405/biprws/infostore/Categories" rel="up" />
   <content type="application/xml">
      <attrs xmlns="http://www.sap.com/rws/bip">
         <attr name="id" type="int32">123456</attr>
         <attr name="cuid" type="string">AbcFHCNUZ7ZLieEoMfzOTeQ</attr>
         <attr name="description" type="string" />
         <attr name="name" type="string">Category Name</attr>
         <attr name="type" type="string">Category</attr>
      </attrs>
   </content>
</entry>

[Former Member · Accepted solution]

Idea posted on SAP Idea Place to enhance the RESTful Web Services SDK.

RESTful Web Services SDK - Full Access to InfoObjects : View Idea

[former_member197386 · Accepted solution]

Hello Taygan,

Thanks for posting this idea.

I'm just wondering if you tried the API available starting 4.2 to perform a query to the CMS through RESTful API?

Regards,

Anthony

[daniel_paulsen · Accepted solution]

Hi Taygan,

Like Anthony suggested, this can be achieved with a CMS Query in BI4.2 using the following API:

POST     .../biprws/v1/cmsquery

body:

<attrs xmlns="http://www.sap.com/rws/bip">

    <attr name="query" type="string">Select SI_DOCUMENTS from CI_INFOOBJECTS where SI_NAME ='Category Name'</attr>

</attrs>

the response will return a list of SI_DOCUMENTS in the category.

Category Management APIs are currently being worked on and should be available in an up-coming Support Package in BI4.2.

Dan

[Former Member · Accepted solution]

This is really cool. I just had a look at the document. Waiting to get a 4.2 server to start exploring.

Thanks for the information Dan

Regards,

Prithvi

[Former Member]

Thanks all,

Confirms that we will need to revert back to the Java SDK for now as we are working with 4.1 SP5. Good to know that this enhancement has been delivered in 4.2.

For those that are interested, relevant documentation can be found within the SAP BI 4.2 BIPRWS Developer Guide - https://websmp205.sap-ag.de/~sapidb/012002523100015666522015E/sbo42_bip_rest_ws_en.pdf (Section 7.1 - CMS Query, Page 174).

[Former Member]

Try using URL /biprws/infostore/<si_id>/children

Thanks,

Prithvi

[Former Member]

Hi Prithviraj,

I had already tried the ./children but there are no additional details at that depth (it seems) for Categories.

[Former Member]

True, you would not get the level of details which you can see through Query builder or Platform java SDKs.

As far as I know, the major focus seems to be on raylight(webi) restful web services currently. Hope there would be enhancements coming up in future releases for platform rest web services.

However, if you would want these details using SDKs, you can use the BI Platform java sdks.

Thanks,

Prithvi