If i writes an api for custom reports using private app credentials and shopifyQL. it returns empty result. i am new to shpoify.
Topic summary
Custom report creation via Shopify Reports API using private app credentials and ShopifyQL is returning an empty/blank response when called from Postman.
Key details provided:
- Goal: fetch a product list ranked by sales for the last month.
- Request: GET /admin/api/2021-10/reports.json with parameters like name=cu and shopify_ql set to a query (e.g., “SHOW total_sales BY order_id FROM sales SINCE -1m UNTIL yesterday ORDER BY total_sales”).
- Result: API returns a blank object/empty result.
Troubleshooting status:
- A request was made for more information and a code screenshot.
- No resolution was reached; the helper ultimately stated they couldn’t help further.
- Open questions remain about correct endpoint usage, query formatting/encoding, and required permissions or report creation steps.
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.