FulfillmentEvents
Retrieves the history of events associated with one or many fulfillments.
Table-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the FulfillmentId column, which supports the '=' comparison operator.
The connector processes other filters client-side within the connector.
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. |