Skip to Content
0

How to get Webi Report data in JSON format

Dec 28, 2017 at 06:33 PM

76

avatar image
Former Member

Hi,

Could you please suggest the options to export the WebI Report data in Json format.

I know using Report Elements you can export report data to JSON format.

I have multiple blocks in my Webi Report. Using report elements, I have to call api multiple times.

Is there way to export the Webi report data to JSON other than reporting elements option in single call to BOE

Please suggest

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

3 Answers

Joe Peters Dec 28, 2017 at 06:57 PM
0

You can retrieve raw query data in CSV format or XML, but not JSON. See here: https://help.sap.com/viewer/58f583a7643e48cf944cf554eb961f5b/4.2/en-US/45f89e086e041014910aba7db0e91070.html

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 28, 2017 at 07:21 PM
0

Thanks Joe.

I am looking for Report data export options and not with Data Provider.

Below is another option to export the Report data in pages. Again here its not possible in JSON.

https://help.sap.com/viewer/58f583a7643e48cf944cf554eb961f5b/4.2/en-US/45f8d5936e041014910aba7db0e91070.html

Is there any other workaround to get the report data in JSON. Can someone throw some light on this?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

In your question you said that you did not want the data from report blocks -- so I do not know what you are hoping to get.

0
Ayman Salem Jan 01 at 12:31 AM
0

Use accept:text/json and you will receive the report in JSON format

....


restapi-json1.jpg (88.0 kB)
restapi-json2.jpg (41.7 kB)
Share
10 |10000 characters needed characters left characters exceeded