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

[mahongwei]

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.

[CloudlabSam · Accepted solution]

Have you looked at ShopifyQL?

https://shopify.engineering/shopify-commerce-data-querying-language-shopifyql

[mahongwei]

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.

[Szopz]

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?