API order fulfillment data

[Leviosa]

Trying to filter fulfilled orders:

When I send this, I correctly get details for only partially filled orders:

/admin/api/2020-10/orders.json?limit=10&fulfillment_status=partial&created_at_min=2023-06-04&created_at_max=2023-06-10

When I send this, I get details, but for unfulfilled order (none fulfilled):

/admin/api/2020-10/orders.json?limit=10&fulfillment_status=fulfilled&created_at_min=2023-06-04&created_at_max=2023-06-10

When I send this, I get no order details at all, even though plenty of orders have been fully fulfilled during these dates:

/admin/api/2020-10/orders.json?limit=10&fulfillment_status=shipped&created_at_min=2023-06-04&created_at_max=2023-06-10

How to filter order details for fulfilled orders only, and then also for fulfilled AND partial orders?

[Liam]

Hi Leviosa,

To filter order details for fulfilled orders only, you can use the fulfillment_status filter with a value of fulfilled. 

EG: /admin/api/2020-10/orders.json?limit=10&fulfillment_status=fulfilled&created_at_min=2023-06-04&created_at_max=2023-06-10

To filter order details for both fulfilled and partially fulfilled orders, you can use the fulfillment_status filter with a value of fulfilled,partial. 

EG: /admin/api/2020-10/orders.json?limit=10&fulfillment_status=fulfilled,partial&created_at_min=2023-06-04&created_at_max=2023-06-10

Hope this helps!

[Leviosa]

Hi Liam-

Thanks for replying.

We already tried what you suggest - see details in my first note.  While this command line returns proper data - see attached output file 'Partial' (shortened and private data cleared):

 /admin/api/2020-10/orders.json?limit=10&fulfillment_status=fulfilled&created_at_min=2023-06-04&created_at_max=2023-06-10

This command line incorrectly returns UNfulfilled orders - see attached output file 'Fulfilled':

 /admin/api/2020-10/orders.json?limit=10&fulfillment_status=fulfilled&created_at_min=2023-06-04&created_at_max=2023-06-10

The only difference between the command lines is 'partial' vs. 'fulfilled'.  When 'shipped' is substituted, response is: 

{"orders":[]}