CODEWITHSUNDEEP
restbusiness-intelligencebusiness-objects
svsLm
svsLm

Reputation: 127

How to get all the data of a report in BI using REST API?

I have a report created using query in SAP BI launchpad, now I want to get all the data in the report created using GET method from advanced REST client.

To request the URL with GET method, what are the parameters to be given to get all the data of a report?

Base URL: http://<server_name>:6405/biprws/

Upvotes: 0

Views: 3352

Answers (1)

Arnaud Develay
Arnaud Develay

Reputation: 3970

You can either retrieve the data of a report or the data of a dataprovider (ie: a query).

Retrieving data from a dataprovider (you will need 3 calls for non trivial document):

Getting the list of dataproviders

[GET] http://<hostname>:6405/biprws/documents/<documentID>/dataproviders

Getting the flow count of dataproviders (could be more than 1 in case of incompatible objects; when there are contexts in the query).

[GET] http://<hostname>:6405/documents/<documentID>/dataproviders/DP0/flows/count

Getting the data of a flow:

[GET] http://<hostname>:6405/documents/<documentID>/dataproviders/DP0/flows/0

Retrieving data from a report

Getting the list of reports in a document

[GET] http://<hostname>:6405/documents/<documentID>/reports

Export the content of the report as CSV 

[GET] http://<hostname>:6405/documents/<documentID>/reports/<reportID>

Send this last request with an Accept header equals to text/csv

For more information, you should have a look to the online documentation.

Upvotes: 1

Related Questions