Encountered error while executing the query in shopifyQLResolve

Partner Discussions
,
1

Hi everyone,

I’m running into an issue when trying to execute a ShopifyQL query using the example provided in the Shopify documentation (or relevant link if you have it).

Here’s the query I’m using:

shopifyqlQuery(query: "FROM orders SHOW sum(net_sales) AS monthly_net_sales GROUP BY month SINCE -3m ORDER BY month") {
    __typename
    ... on TableResponse {
      tableData {
        unformattedData
        rowData
        columns {
          name
          dataType
          displayName
        }
      }
    }
    parseErrors {
      code
      message
      range {
        start {
          line
          character
        }
        end {
          line
          character
        }
      }
    }
  }
}

When I run this, I get the following error message:
Encountered error while executing the query in shopifyQLResolve

I’ve double-checked the syntax and it matches the example from the docs. Could this be an issue with permissions, data availability, or a recent change in the API?

Would appreciate any insights or suggestions from anyone who has faced a similar issue.

Thanks in advance!