Get Orders using processed_at filtering results

Highlighted
Excursionist
32 0 7

I'm making a request to list all Orders using the processed_at filters to just get orders processed between 2 timestamps. Here's the URL I'm using for the GET request:

 

admin/api/2019-10/orders.json?status=any&limit=250&processed_at_min=2020-05-12T10:42:00+08:00&processed_at_max=2020-05-18T18:09:00+08:00&order=processed_at%20asc

 

There's a few Orders that are returned that are outside the processed_at range that we're using - here's the processed_at values for these orders that are returned:

"processed_at": "2020-05-18T19:40:23+08:00"

"processed_at": "2020-05-18T21:47:15+08:00"

"processed_at": "2020-05-18T22:54:39+08:00"

Any reason these Orders are being returned where the processed_at value is after the processed_at_max value we specify in the request (2020-05-18T18:09:00+08:00)?

0 Likes
Highlighted
Shopify Partner
520 38 109

I know that using the GraphQL API to query against order datetime ranges it seems as if only the date is being honored. It appears as if the time is ignored. Perhaps the REST API has the same quirk? 

0 Likes