Is it possible to get the data from a report via the REST or graphQL API?

I am trying to retrieve total sales for my stores via the graphQL API, ideally it would be in the format as this endpoint:

  1. Request URL:
    https://analytics.shopify.com/queries?beta=true&dataOnly=false

  2. Query: “SHOW orders, gross_sales, discounts, returns, net_sales, shipping, duties, additional_fees, taxes, total_sales FROM sales SINCE 2022-10-29 UNTIL 2022-10-29”

I have attempted to use “shopifyqlQuery” but have only received errors

I was able to get the shopifyqlQuery working by changing the version to “unstable”

Hey! I’m really struggling to receive a successful response. I’d be super interested in talking to you. I’m on +44 7496 898 721. Happy to pay for any time