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:
"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
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!