I am trying to get order data via shopifyQl. I already have 5 orders in my Shopify backend. I use the PHP GraphQl client from the Sopify package. However my request returns only 0. Can anyone help me and know where I need to change something. $since and $until are in the correct format no matter what values I use it does not work. My query: <<QUERY query { shopifyqlQuery(query: "FROM orders SHOW sum(gross_sales) AS daily_sales GROUP BY day ALL SINCE $since UNTIL $until ORDER BY day") { __typename ... on TableResponse { tableData { unformattedData rowData columns { name dataType displayName } } } parseErrors { ... } } } QUERY;
Response: "data": { "unformattedData": [ [ "2023-03-01T00:00:00-05:00", 0 ], [ "2023-03-02T00:00:00-05:00", 0 ], [ "2023-03-03T00:00:00-05:00", 0 ], [ "2023-03-04T00:00:00-05:00", 0 ], [ "2023-03-05T00:00:00-05:00", 0 ], [ "2023-03-06T00:00:00-05:00", 0 ], [ "2023-03-07T00:00:00-05:00", 0 ] ], }
But there are orders on 2023-03-06