Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Reporting through query API

Received Response
21
Views
5
Comments
Rank 2 - Community Beginner

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,

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 5 - Community Champion

    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

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

  • Rank 2 - Community Beginner

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

  • 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.

  • Rank 2 - Community Beginner

    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.

Welcome!

It looks like you're new here. Sign in or register to get started.