Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 10 Oracle Analytics Lounge
- 189 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 65 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Reporting through query API

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,
Answers
-
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
0 -
-
No it was not related to OBIEE, however related to reporting. Thanks
0 -
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.
0 -
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.
0