How to get Reports SQL using REST SDK in BO4.1 ?

[Former Member]

Hi,

I need reports sql using REST or any other SDK. Kindly let me know if it is possible in BO 4.1 ?

Thanks in advance .

Regards,

Mithila Suvarna

[Former Member]

Hi Mithila,

Yes, this is possible in BI 4.1.

You can get the SQL of the Webi document's data provider.

Please use the following:

URL: http://<server-name>:<port>/biprws/raylight/v1/documents/{document-d}/dataproviders/{data-provide-id}

Method: GET

Headers: Content-Type: application/xml

               X-SAP-LogonToken: "<Your X-SAP-Logon-Token>"

Your SQL query is present in the tag <query>of the above REST URL.

You can also get more detail in the Webi REST Developer Guide.

Hope this helps.

Thanks,

Shailendra