If i writes an api for custom reports using private app credentials and shopifyQL. it returns empty result. i am new to shpoify.
Hello, can you send you more information, and a picture of your code please.
Basically, I want to create a custom report using reports API. I would like to fetch product list based on sales for last one month. Whenever I am hitting the API from postman, it is returning blank object. I am attaching the API URL below.
https://myApiKey:myApiPass@myshopname.myshopify.com/admin/api/2021-10/reports.json?api_version=2021-10&name=cu&shopify_ql=“SHOW total_sales BY order_id FROM sales SINCE -1m UNTIL yesterday ORDER BY total_sales”
Sorry i couldn’t help you.