Empty response for yesterday ShopifyQL

[anastasia_mch]

Hi!

I’m getting empty API responses for ShopifyQL query request when requesting data SINCE yesterday (both with “yesterday” preset and actual date). Data for other days is okay.

Request and response:

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

Please help.