Understood and appreciate the help. Comment on your sample. I had originally used similar approach but had to abandon it because of the query cost, due to the nested items. For example, limiting to 5 lineitems. It's quite reasonable for an order to h...

Thanks for the example, that may get me some of the data I need for refunds for a day at least. Will still have to query orders to get cost of goods sold, and break out shipping and tax. In order to calculate profit.  I really don't understand the pu...

Yes, I've implemented a process as you've described, getting orders for a given date and summing them. However, I need to also get refunds which apparently are NOT directly query-able by date, one must go though orders. So I can can keep banging my h...

Yes, but neither of REST API or GraphQL api provides access to running queries with ShopifyQL. Pulling down every order to get a summary of what was sold and and refunded for the day seems absurd, when there's a perfectly good solution already implem...

Thanks, but that not exactly the use case I'm describing. We do not want to view the report in the Shopify dashboard. We need to fetch this data for insertion into a separate data warehouse for our accounting team. Hence the need for REST access to t...

I too would like like to query the sales data using ShopifyQL via REST for accounting purposes. Why is this not exposed from the REST API?  It has to be less resource intensive than fetching all the orders and manually aggregating the data, as i'm cu...