Internal query API's public equivalent ("api/internal/querymanager/queries")

mehmety
Participant I

Hi,

It looks like you are using following endpoint in your dashboard(“POST api/internal/querymanager/queries”), I need its public equivalent.

It looks like current public query endpoints doesn’t return similar data and I couldn’t find an API that give this detailed data.

Basically I want to get formatted data with subtotals and totals, this endpoint already does that. How can I achieve this? If you don’t have it currently, is there a plan to create an endpoint like this for public API?

Thanks

0 2 340
2 REPLIES 2

leobardor
Participant V

Hi Mehmetry. 

Can you please share which API method are you using?

There are some options in the API explore :

https://developers.looker.com/api/explorer/4.0/methods/Query/query

https://developers.looker.com/api/explorer/4.0/methods/Query/run_query

Regards

Leo

mehmety
Participant I

Hi Leo,

I’m using following API method. It accepts a few parameters but it is very limited. It doesn’t support totals or pivot.

And also when you request formatted data, it doesn’t return original data at all, only returns formatted data. It would be good to get both of them.

If you can suggest any other endpoint in API 3.1 or API 4, I’m happy to try them.

GET/api/3.1/queries/{query_id}/run/{result_format}