shopifyqlQuery has been great so far. We’ve been using it for a while and it worked reliably up until a few weeks ago. Since then, we’ve started getting repeated “Rate limited. Please retry later” errors on queries that previously ran without any issues.
What’s confusing is that the exact same queries run successfully in the Exploration UI, but fail when executed through the API.
For example this one:
FROM sales SHOW amount_spent_per_customer, number_of_orders_per_customer GROUP BY customer_name, customer_email WITH TOTALS ORDER BY amount_spent_per_customer DESC, number_of_orders_per_customer DESC
I know that the docs say that there are limits, but is this an expected one?