Get merge queries data

Baptiste_guer · 03-08-2024 04:48 AM

Hello, I m trying to get a solution to extract merge query data in json via API, is it possible ?

Ryan_PS

We're dealing with the same problem. The `merge_query` end point returns query IDs for each query/explore used in the Merge Query, but that means we need to make 3 separate responses (via the "Run Query" endpoint) and merge the data our self, which defeats the purpose of a merge query.

merge_query endpoint: https://looker.com/extensions/marketplace_extension_api_explorer::api-explorer/4.0/methods/Query/mer...

Note: To call `merge_query`, we call the get dashboard endpoint to get the `merge_result_id`, which is then used in the `merge_query` endpoint: https://looker.com/extensions/marketplace_extension_api_explorer::api-explorer/4.0/methods/Dashboard...

Additionally, any user that wants to request data from the `merge_query` endpoint must also have the "explore" permission. This is because merge queries aren't a normal look or dashboard. They behave like an explore (i.e. a temporary explore that you haven't saved yet as a look or as a dashboard tile).

Ryan_PS

I did find this article from 2019, which states this isn't possible (see last line of the post): https://www.googlecloudcommunity.com/gc/Technical-Tips-Tricks/Where-is-my-merged-query-id/ta-p/59232...

This is currently a feature request. Go to Looker > on the top right, click "Product Idea?" above the "Get Support" button. This will open Looker's pendo site and authenticate you. Then, paste this link: https://portal.feedback.us.pendo.io/app/#/case/54383?currentProductId=53ee6715-9dcb-471f-bd41-7846ac...

Finally, you can click upvote under "Request Actions" (not under "Request Activity").