API for all open unfulfilled and fulfilled orders

I am trying to run an API GET request to find every order that is open and is currently unfulfilled or partially fulfilled. When I run this search under the order page within the Shopify store I get ~420 results.

My current endpoint is:

‘orders.json?fields=order_number,fulfillment_status,updated_at&status=any’

When I run this I get back 50 results. I’ve tried

‘orders.json?fields=order_number,fulfillment_status=unshipped,updated_at&status=any’

I get the same 50 results just without the fulfillment status included in the output.

Replying to this because I solved my issue and I cannot delete this post.

The final API call looks like this:

orders.json?fields=order_number,created_at,fulfillment_status&fulfillment_status=unshipped&limit=250

The only issue I am now running into, is that if someone orders multiple things that are under 1 order number I do not see the individual status. For example I have order number 12345 and they ordered 4 different items which could all be fulfilled independently of one another, I don’t see 4 orders with the same order number with the API call like I do just exporting the order list to a csv file

1 Like