Get Orders using processed_at filtering results

Andrew_Duncan
Shopify Partner
38 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)?

Reply 1 (1)
Gregarican
Shopify Partner
1030 86 276

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?