FulfillmentEvents
Retrieves the history of events associated with one or many fulfillments.
Table-Specific Information
Select
The add-in uses the Shopify API to process WHERE clause conditions built with the FulfillmentId column, which supports the '=' comparison operator.
The add-in processes other filters client-side within the add-in.
For example, the following query is processed server-side:
SELECT * FROM FulfillmentEvents WHERE FulfillmentId='VALUE'
Insert
INSERT statements are mapped to the 'fulfillmentEventCreate' GraphQL mutation.
The following columns can be used to create a new record:
FulfillmentId, Status, Address1, City, Country, Latitude, Longitude, Message, Province, Zip, EstimatedDeliveryAt
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
A globally-unique ID. | |
FulfillmentId | String | True |
Fulfillments.Id |
A globally-unique ID. |
OrderId | String | True |
Orders.Id |
A globally-unique identifier. |
Status | String | True |
The status of this fulfillment event. | |
HappenedAt | Datetime | True |
The time at which this fulfillment event happened. | |
Address1 | String | True |
The street address where this fulfillment event occurred. | |
City | String | True |
The city where this fulfillment event occurred. | |
Country | String | True |
The country where this fulfillment event occurred. | |
Latitude | Double | True |
The latitude where this fulfillment event occurred. | |
Longitude | Double | True |
The longitude where this fulfillment event occurred. | |
Message | String | True |
A message associated with this fulfillment event. | |
Province | String | True |
The province where this fulfillment event occurred. | |
Zip | String | True |
The zip code of the location where this fulfillment event occurred. | |
EstimatedDeliveryAt | Datetime | True |
The estimated delivery date and time of the fulfillment. |