My GraphQL shopifyqlQuery no longer returning results for time dimension "today"

brandonyano
Tourist
4 0 1

I have a script that gets run hourly that I've been running the past couple of weeks with no issues that returns daily data from the current month, up to and including data for today. After midnight last night, I started getting errors because the API is no longer returning results for "today", only the previous days in the month. Here is my query:

"FROM sales SHOW net_sales,gross_profit,orders,total_cost,returns GROUP BY day WHERE channel_name = 'Online Store' SINCE this_month UNTIL today"
Replies 2 (2)

brandonyano
Tourist
4 0 1

It is back to working now.

ComertiseTeam
Shopify Partner
4 0 3

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 for WhatsApp. Happy to pay for any time