Solved

How to query Shopify backend report data through an API interface?

mahongwei
Not applicable
3 0 0

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.

Accepted Solution (1)

CloudlabSam
Shopify Partner
538 43 87

This is an accepted solution.

Replies 2 (2)

CloudlabSam
Shopify Partner
538 43 87

This is an accepted solution.

mahongwei
Not applicable
3 0 0

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](https://shopify.dev/api/shopifyql/datasets). I checked the link and found that there are only 3 types of Datasets.2024-03-15_094156.jpg2024-03-15_093625.jpg2024-03-15_094759.jpg