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.
Daniel Paulsen 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.