Order REST API missing orders when queried by updated_at_min

Retired Boards Appdev Customers Discounts And Orders
1

Hi,

I have an order:

{
    "order": {
        "id": 3993502974120,
        "updated_at": "2021-07-14T10:12:01-07:00"
    }
}

But when I make the following query:

https://rmmc-shopquick.myshopify.com/admin/api/2021-04/orders.json?updated_at_min=2021-07-13T17:11:01Z&fields=id,updated_at&limit=250

It is not included in the results, which are as follows:

{
    "orders": [
        {
            "id": 3998316036264,
            "updated_at": "2021-07-15T12:12:01-07:00"
        },
        {
            "id": 3997350887592,
            "updated_at": "2021-07-15T08:49:26-07:00"
        },
        {
            "id": 3996930441384,
            "updated_at": "2021-07-15T06:38:21-07:00"
        },
        {
            "id": 3994577961128,
            "updated_at": "2021-07-14T14:51:28-07:00"
        },
        {
            "id": 3994395705512,
            "updated_at": "2021-07-14T14:11:59-07:00"
        },
        {
            "id": 3991060840616,
            "updated_at": "2021-07-13T14:43:18-07:00"
        },
        {
            "id": 3990614442152,
            "updated_at": "2021-07-13T11:02:15-07:00"
        },
        {
            "id": 3968894009512,
            "updated_at": "2021-07-13T12:04:21-07:00"
        },
        {
            "id": 3968162889896,
            "updated_at": "2021-07-15T10:20:37-07:00"
        },
        {
            "id": 3912317763752,
            "updated_at": "2021-07-15T06:55:37-07:00"
        }
    ]
}

Notice how I am using UTC (Z) for the timezone. I even set it back a full day before to make sure the timezone issues that everyone talks about with Shopify’s API can be taken out of the equation.

Can anyone explain how I am not receiving the full list of orders?

Thanks,

Brendan

2

The missing order is a POS order, if that helps. Nothing in the documentation seems to suggest that these shouldn’t be included right alongside web orders, as far as I can tell.