How to get Webi Report data in JSON format

[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

[ayman_salem]

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

....

[Former Member]

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/45f8d5936e041014910aba7db0e91...

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

[Joe_Peters]

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.

[Joe_Peters]

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/45f89e086e041014910aba7db0e91...