Unable to get reports with API

6 0 1

Hi there,


I've been trying to get a sales report through the custom API call on Integromat and I am not able to receive any values.

The Report was successfully created and I have the ID #, but when I try to retrieve the report with the GET functionality, it only gives back the report id and query. No results. 

This is what I have:

"report": {
"name": "Total Sales report from yestday",
"shopify_ql": "SHOW sales BY order_id FROM sales SINCE -1d UNTIL today"

How can I get this to work? I see there are other threads similar to this but couldn't find any solutions.

Hoping to get some help

Thank you!

125 6 9

I don't believe the Admin API can be used to return results, only manage custom reports. See this thread - https://community.shopify.com/c/Shopify-APIs-SDKs/How-to-download-reports-data-via-api-s/td-p/105548....

We have a free app called Report Toaster that would allow you to get any data you need. Please feel free to take a look and let me know if you have any questions. Thanks!