Clarification Needed: Is the 'updated_at_max' Filter in Shopify API Inclusive or Exclusive?

Retired Boards Appdev Customers Discounts And Orders
1

I’m currently working with the Shopify Order API and have a question regarding the behavior of the updated_at_min and updated_at_max filters. Specifically, I’m trying to retrieve orders from a specific day, and I’m unclear on whether the updated_at_max filter is inclusive or exclusive of the time specified.

Here’s my scenario: I want to fetch orders updated on a particular day (e.g., yesterday). I’m using updated_at_min to specify the start of the day (e.g., 2023-11-19T00:00:00) and updated_at_max for the end of the day (e.g., 2023-11-19T23:59:59). My question is, does the updated_at_max parameter include orders that were updated exactly at 2023-11-19T23:59:59.999, or does it exclude them?

Should I specify updated_at_max at the beginning of the next day (e.g., 2023-11-20T00:00:00) to fetch all of yesterday’s orders?

I couldn’t find a clear answer in the Shopify API documentation and was wondering if anyone here has experience or insight into this. Any clarification or guidance on how the updated_at_max filter behaves in this context would be greatly appreciated.

Thank you in advance for your help!

2

Hey @keiya ,

Orders are recorded to the current second. An order placed at 23:59:59.999 would have a created_at time of T23:59:59. An updated_at_max of T23:59:59 would include this order.

3

Thank you very much for your clear and detailed explanation!