Get all the metadata of webi report using pyhton script

[melader]

Hi,

I was trying to get all the metadata including the query of Webi reports from the Python scripts, I can get all metadata except the query using the Restful APIs, can anyone please help me with the right API that will help to get the query of the report?

Thanks

[xiaoping_zheng · Accepted solution]

Do you want to get the SQL of the webi query? If so, I think this API should be what you want:

GET /documents/<documentID>/dataproviders/<dataProviderID>/queryplan

More details, you can check help guide:

https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/5431204882b44fc98d56bd7...

[melader · Accepted solution]

Thank you so much