Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Create reports in RESTful webservice


Hi

I am using BO 4.1 SP2.

I know that report can be created using restful url.

Is there any url to connect the created report with a particular universe. help me in this

Regards,

Kavitha S

Former Member
replied

Hi Mithila.

you can get the ID of the universe to add by requesting the list of uinverses.  Here's a simple workflow of creating a report and adding a dataprovider:

List out the universes

GET /biprws/raylight/v1/universes

response

<universes>
...
<universe>
  <id>5145</id>
  <cuid>AX3cE9nWhMBLtXyWJ56OoDQ</cuid>
  <name>eFashion</name>
  <type>unv</type>
  <folderId>532</folderId>
</universe>
...
</universes>

====================================
Create a document

POST /biprws/raylight/v1/documents

<document>
  <name>My new Document</name>
  <folderId>5848</folderId>
</document>

response

<success>
  <message>The resource of type "Document" with identifier "6757" has been successfully created.</message>
  <id>6757</id>
</success>

=====================================
Add a datasource to the new document (6757) using the name and ID from the universe you want to use

POST /biprws/raylight/v1/documents/6757/dataproviders

<dataprovider>
  <name>eFashion</name>
  <dataSourceId>5145</dataSourceId>
</dataprovider>

response

<success>
  <message>The resource of type "Data provider" with identifier "DP0" has been successfully created.</message>
  <id>DP0</id>
</success>

======================================
List the dataproviders in the new webi document

GET /biprws/raylight/v1/documents/6757/dataproviders

response

<dataproviders>
  <dataprovider>
    <id>DP0</id>
    <name>eFashion</name>
    <dataSourceId>5145</dataSourceId>
    <dataSourceType>unv</dataSourceType>
  </dataprovider>
</dataproviders>

I hope this helps,

Dan

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question