Hi,
I am new into Shopify API and am confused by the resulting payload from the REST API.
I am able to connect and create a report using:
POST /admin/api/2020-10/reports.json
However, when I retrieve the report using:
GET /admin/api/2020-10/reports/517154478.json
The payload doesn't actually contain any of the results of the actual report. The payload is only the report
HTTP/1.1 200 OK { "report": { "id": 517154478, "name": "Changed Report Name", "shopify_ql": "SHOW total_sales BY order_id FROM sales SINCE -12m UNTIL today ORDER BY total_sales", "updated_at": "2020-11-04T19:36:55-05:00", "category": "custom_app_reports" } }
How the heck do I actually query the results of that report? E.g. How do I return the total sales in the payload?
Solved! Go to the solution
This is an accepted solution.
This API endpoint is just for managing reports. As for actually running them (presumably using the Shopify QL), you would need to use the Embedded App SDK. Explained here --> https://shopify.dev/docs/admin-api/rest/reference/analytics/shopify-ql.
User | Count |
---|---|
29 | |
7 | |
7 | |
6 | |
5 |