Discussing APIs and development related to customers, discounts, and order management.
Allow me to demonstrate. The following request attempts to fetch the orders where processed_at occurs between 2019-08-31 00:00:00 UTC and 2019-08-31 23:59:59 UTC. (So, the entire day, 2019-08-31 UTC).
https://abc-store.myshopify.com/admin/api/2019-10/orders.json?limit=250&since_id=0&processed_at_min=2019-08-31T00%3A00%3A00-00%3A00&processed_at_max=2019-08-31T23%3A59%3A59-00%3A00&status=any
However, the request returns orders whose minimum processed_at value is 2019-08-30T01:44:15-07:00 which equals 2019-08-30 08:44:15 UTC, clearly before the processed_at_min parameter I specified.
Some important notes regarding this:
1. I'm certain these parameters worked in the past. Sometime in the last 30 days, they've stopped working properly
2. The same exact query applied to the order_counts() endpoint suggests that I should be getting back 173 records, but when I run it on the orders() endpoint I get back 250 records (which is probably cut off due to the 250 records per request limit)
3. I wonder if this bug is related to this issue.
4. I've tested the same type of query using the created_at_min and created_at_max parameters, and these parameters appear to work properly
5. The one example I gave is not a one-off. I can find other errors regarding other dates as well.
Thanks
Just now realizing that this bug was introduced in the 2019-10 API, but it appears the 2019-07 API still works. phew 🙂
Has anyone read this? Any thoughts on the matter? I cannot use the 2019-10 API forever. Thanks
I'm seeing the same issue - using both processed_at_min and processed_at_max on 2019_10/orders.json returns orders *after* processed_at_max.
Also confirming this works correctly in 2019-07 but not in 2019-10, 2020-01 or 2020-04.
Can confirm this bug is still occurring with latest API version - tested on API version 2021-01 on the 2021-05-11. Had to revert request to API version 2019-07 to enable correct response rather than html doc saying I am being redirected to admin dashboard.