Sales Over Time Report Data

New Member
7 0 0

hi ,

 I would like to get the following data (screenshot) which i get by creating a Custom Report in shopify admin and export it to .csv by using REST Admin Api.

i have a private app on which I have given read/write permission to Reports in Admin API Permissions.  Now after creating a new report and then retrieving the same report using GET /admin/api/2020-10/reports/{report_id}.json , it only gives me few fields like name, shopify_ql, updated at and category name. How can i get the actual report data by using ShopifyQL ? 

i.e i would like the get the fields like day, order_id, api_client_title, referrer_name, etc as show in screenshot thro REST Api. But i don't know how to query using ShopifyQL.

Could anyone please help?