Skip to Content

How to create a webi report based on universe using RESTful SDK

The following workflow is used. Content type and SAP Logon token are passed in each request not mentioned below.

Post

http://server:6405/biprws/raylight/v1/documents/

<document> <name>REST Document</name> <folderId>410469</folderId> </document>

200 - Able to see a blank document in the folder.

Post

http://server:6405/biprws/raylight/v1/documents/410572/dataproviders

<dataprovider> <name>REST DP</name> <dataSourceId>310173</dataSourceId> </dataprovider>

200

Get

http://server:6405/biprws/raylight/v1/documents/410572/dataproviders/DP0

200

Able to see the query properties. Now how to add the objects in select clause and where clause.

I tried PUT

http://server:6405/biprws/raylight/v1/documents/410572/dataproviders/DP0

<dataprovider> <dictionary> <expression dataType="Numeric" qualification="Dimension"> <id>DS0.DOb9</id> <name>Month</name> </expression> </dictionary> </dataprovider>

Even I tried

PUT

http://server:6405/biprws/raylight/v1/documents/410572/dataproviders/DP0/specifications

http://www.w3.org/2001/XMLSchema-instance" xmlns:queryspec="http://com.sap.sl.queryspec" dataProviderId="DP0">

Nothing helped me. Kindly guide me.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 30, 2017 at 05:00 PM

    Hi Subramanian

    After adding the dataprovider to the document, you will need to add the query specification with the query containing the result objects.

    If you have a document designed using this dataprovider, you can retrieve the specification of that document to see what the body should look like. Your workflow would be:

    1. POST http://server:6405/biprws/raylight/v1/documents/
    2. POST http://server:6405/biprws/raylight/v1/documents/410572/dataproviders
    3. PUT http://server:6405/biprws/raylight/v1/documents/410572/dataproviders/DP0/specification
      the body of this PUT will have the query specification (similiar to the format you would retrieve from an existing document).
    4. PUT http://server:6405/biprws/raylight/v1/documents/410572 to save the changes

    Dan

    Add comment
    10|10000 characters needed characters exceeded