Running query against universe and return results

[Former Member]

Hi,

I have a custom sql that is used in a report. Can i run the same custom sql against a universe and get the results? I was searching the WS document and found this -

• Runs the query using GET <slURL>/queries/{queryId}/data.svc
• Returns the query results using GET <slURL>/queries/{queryId}/data.svc/{flowName}ArunI am not clear on this part "queries/{queryId}/data.svc/{flowName}".  Are "queries" the actual custom sql? What is queryId? Also how to find the flowName?Any help appreciated.Thanks,
  
  

[daniel_paulsen · Accepted solution]

Hi Arun,

to run a query against a universe, you first have to create it by passing in a valid specification,

POST  /queries

     body = a valid query specification

Creating the query will return a long number which is the ID of the query (<queryId>).  This <queryId>  is then used on the URL to access the query.  the query is only valid for the lifetime of the session token used to create it.  It is not stored in the CMS repository.

You can retrieve the IDs of queries created within your current logon session using:

GET /queries

The flow names (if a query has multiple flows), can be retrieved by returning the query's metadata

GET  /queries/<queryId>/data.svc/$metadata

Dan