I would like to directly retrieve report data through an API interface, instead of using the REST API to fetch order data for relevant statistics.
Topic summary
Main issue: Directly querying Shopify’s backend report metrics via an API, rather than aggregating via REST, and limits when using ShopifyQL.
Recent update: ShopifyQL was tried using statements seen in Admin reports (e.g., SHOW total_sessions, total_carts, total_checkouts, total_orders_placed, total_conversion FROM visits SINCE yesterday UNTIL yesterday). The API returns “visits is an invalid dataset,” and the documentation lists only three available datasets.
Key points:
- ShopifyQL: Shopify’s commerce data querying language; queries run against defined datasets (i.e., specific tables exposed by the API).
- The “visits” dataset used by Admin reports appears not exposed to ShopifyQL for apps, causing errors when reproducing those report queries.
- Screenshots and network captures from Chrome DevTools are central to understanding the attempted query and the Admin report’s internal requests.
Open questions:
- Whether Admin report datasets (e.g., visits) are accessible via any public API.
- If not, whether only the three documented datasets can be queried.
Status: Unresolved. Another participant reports the same issue and asks if a solution exists or if access is limited to those three datasets.
Have you looked at ShopifyQL?
https://shopify.engineering/shopify-commerce-data-querying-language-shopifyql
Thank you very much. I use ShopifyQL, but I still cannot view some of the data in the report. I accessed the shopify backend report and found the corresponding network request and the corresponding ShopifyQL statement through the Google Chrome developer tools, such as SHOW total_sessions, total_carts, total_checkouts, total_orders_placed, total_conversion FROM visits SINCE yesterday UNTIL yesterday LIMIT 1000, I changed it to FROM visits SHOW total_sessions, total_carts, total_checkouts, total_orders_placed, total_conversion SINCE yesterday UNTIL yesterday, prompting that visits is an invalid dataset in the FROM clause. See documentation for available datasets. I checked the link and found that there are only 3 types of Datasets.
1 Like
Hi. I’m having the same issue, have you found a solution? Is it possible to get these reports or is it only possible to get these three resources?