ShopifyQL is not working for Orders dataset

Technical Q&A
1

Hello Shopify Community members.

Hope you are doing well.

I am now using ShopifyQL to get analytical data from shopify.

I followed shopifyQL docs from here

But the example query is also not working.

{
  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
        }
      }
    }
  }
}

I got empty result.

{
  "data": {
    "shopifyqlQuery": {
      "__typename": "TableResponse",
      "tableData": {
        "unformattedData": [],
        "rowData": [],
        "columns": [
          {
            "name": "month",
            "dataType": "month",
            "displayName": "Month"
          },
          {
            "name": "monthly_net_sales",
            "dataType": "price",
            "displayName": "Monthly net sales"
          }
        ]
      },
      "parseErrors": null
    }
  },
  "extensions": {
    "cost": {
      "requestedQueryCost": 7,
      "actualQueryCost": 4,
      "throttleStatus": {
        "maximumAvailable": 1000,
        "currentlyAvailable": 996,
        "restoreRate": 50
      }

If anybody has an idea about it, please let me know.

PS: If anyone knows how to get analytical data from shopify without shopifyQL, I will be really appreciate your help.

Thank you so much.

1 Like
2

Were you able to figure out a good workaround for this?

I’m running into basically the same issues and trying to figure out a solution for this (probably not using ShopifyQL)