The AssignedFulfillmentOrder resource allows you to retrieve all the fulfillment orders that are assigned to an app at the shop level.

View-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the AssignedLocationId and RequestStatus columns. The connector processes other filters client-side within the connector. For example, the following queries are processed server-side.

SELECT * FROM AssignedFulfillmentOrders WHERE AssignedLocationId IN (1, 2)

SELECT * FROM AssignedFulfillmentOrders WHERE RequestStatus = 'cancellation_requested'

Columns

Name	Type	References	Description
Id [KEY]	Long		The ID of the fulfillment order.
ShopId	Long	Shop.Id	The ID of the shop that's associated with the fulfillment order.
OrderId	Long	Orders.Id	The ID of the order that's associated with the fulfillment order.
AssignedLocationId	Long		The ID of the location that has been assigned to do the work.
FulfillmentServiceHandle	String		A unique numeric identifier for the order.
RequestStatus	String		The status of the fulfillment.
DestinationId	String		The ID of the fulfillment order destination.
DestinationAddress1	String		The first line of the address of the destination.
DestinationAddress2	String		The second line of the address of the destination.
DestinationCity	String		The city of the destination.
DestinationCompany	String		The company of the destination.
DestinationFirstName	String		The first name of the customer at the destination.
DestinationLastName	String		The last name of the customer at the destination.
DestinationPhone	String		The phone number of the customer at the destination.
LineItems	String		Represents line items belonging to a fulfillment order.
Status	String		The status of the fulfillment order.
Operation	String		An operation to apply to the fulfillment. Complete, Open, or Cancel.