Can we get universe object SQL by using any restful service

[Former Member]

We are using webi 4.1 SP6. Can we get universe object SQL details by using any RESTFUL service on CMS.

[Former Member]

Hi Dan,

I am able to get the report dataprovider query through SDK. But I am asking universe object defintion through restful or SDK?

Regards,
Madhu

[daniel_paulsen]

Can you please clarify your question a bit?

What do you do now to get the SQL you are looking for? (what tool and workflow: ie Webi query panel and Show SQL or IDT object properties etc...).

If you have a webi report with a dataprovider, then you can get the SQL (queryplan) for the dataprovider's resultobjects using RESTful.

GET /raylight/v1/documents/<docId>/dataproviders/<dpId>/queryplan

Dan

[Joe_Peters]

No.