01-28-2017 6:21 PM - edited 02-03-2024 6:53 PM
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
<queryspec:QuerySpec xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:queryspec="http://com.sap.sl.queryspec" dataProviderId="DP0"> <queriesTree xsi:type="queryspec:QueryOperatorNode" queryOperator="Union"> <children xsi:type="queryspec:QueryDataNode"> <bOQuery name="REST DP"> <resultObjects identifier="DS0.DOc4" name="Month Name" /> <conditionPart/> </bOQuery> </children> </queriesTree> </queryspec:QuerySpec>
Nothing helped me. Kindly guide me.
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:Dan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
74 | |
10 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.