Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BI Universe Connector using Rest API

Using Rest API URL, I can send HTTP calls using Chrome Rest client and can see just the universe metadata like CUID, Description, Type etc.Using <Resturl>/sl/v1/universes/si_id , I can see the unx universe Folder and object names, Data Type.

I would like to know how to query the universe data as ODATA feed in MS Excel using the Rest API URL. If yes, what needs to be done and what the Odata URL would look like. Any guidance is appreciated.

Former Member
replied

I'm not aware of any document for that, but I have used  /raylight/v1/documents/<docId>/dataproviders/<dpId>/specification to get a query spec and use it to create a new query.  I don't think there's a 1:1 match for the XML, but it contains correct formatting for resultobjects and the sql query.

Dan

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question