processed_at_min and processed_at_max parameters of orders API no longer work properly

Ben83
Shopify Partner
14 0 7

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

Replies 5 (5)

Ben83
Shopify Partner
14 0 7

Just now realizing that this bug was introduced in the 2019-10 API, but it appears the 2019-07 API still works. phew 🙂

Ben83
Shopify Partner
14 0 7

Has anyone read this? Any thoughts on the matter? I cannot use the 2019-10 API forever. Thanks

Lah
Visitor
2 0 0

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.

Lah
Visitor
2 0 0

Also confirming this works correctly in 2019-07 but not in 2019-10, 2020-01 or 2020-04.

breakworm
Tourist
5 2 0

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.