Skip to Content
0

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

Jan 28, 2017 at 06:21 PM

65

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Daniel Paulsen
Jan 30, 2017 at 05:00 PM
1

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

Share
10 |10000 characters needed characters left characters exceeded