I'm facing an issue with the API and I can't find the solution. I want to get all orders from a specific time range (for example this month) which have the financial_status = paid.
I'm using this query (in this example only for counting):
If I run the query for the time range of a day, it works fine. If i run it like above, the result is always 0.
Does anybody have an idea how to solve this?
The query works fine. I am suspecting you do not have any open orders in that time range. To be more exact, querying orders always returns orders with status=open by default. Orders that have been closed won't be included unless you also filter by status=any.
Hope that helps!