Reporting through query API

3241766

Hi All,

I have query related to data access through query API.

Do we supply query via HTTPS request and query API returns a JASON response? is there other ways for querying and viewing results?

If I write a sql query (example select * from Table), how it will be converted to query rest api format?

QUERY REST API is QUERY URL REQUEST?

Any tool or utility which automatically converts a query to query API format?

Thanks,

Rajneesh S-Oracle

Q: Do we supply query via HTTPS request and query API returns a JASON response? is there other ways for querying and viewing results?

Ans: The query can be provided using query parameters or a payload. Response can either be JSON or XML.

Q: If I write a sql query (example select * from Table), how it will be converted to query rest api format?

QUERY REST API is QUERY URL REQUEST?

Any tool or utility which automatically converts a query to query API format?

Ans:

No there is no tool t convert the queries to rest api. The grammer used in very simple to understand and write and even generated. The query above can be re-written as following if the resource corresponding to table is tab1, then the query will look like: /api/generic/tab1(GET ) on this URL. It does not have a query associated with it, since you asking for all information. If suppose the query was like: select * from Table where column1 = ‘abc’ then the query api syntax would be:

/api/generic/tab1?q=column1.eq(‘abc’)

Thanks,

Rajneesh

Gianni Ceresa

Are you talking about OBIEE? Because you posted in but not sure if you really talk about OBIEE here ...

3241766

No it was not related to OBIEE, however related to reporting. Thanks

Gianni Ceresa

So could you please say which exact tool/product (with version etc.) is it about?

In this way a MOD can look at moving the thread in the right place.

3241766

Hello Gianni,

As it is related to REST API and RST API is supported within OBIEE as well to integrate it with other applications, hope it should be OK. Next time I will see any dedicated place related to query API, if there is any.