Looking for a way to search for orders that have delivery failures via admin, rest api, or graphql

Highlighted
Tourist
8 0 2

We have orders that have delivery failures and I'm looking for a way to query all orders and filter by fulfillment shipping status. In the admin, these orders have this status:

 

Screen Shot 2019-06-18 at 3.47.08 PM.png

 

I can't find a way to search for these orders using the admin interface. The order json lists the shipment status as this:

 

"fulfillments": [
{
"id": 0000000000,
"order_id": 0000000000,
"status": "success",
"tracking_company": "FedEx",
"shipment_status": "failure",
},

Is there a way to query for all orders that have these failures with either the rest api or graphql api?

 

0 Likes