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 following columns and operators. The connector processes other filters client-side within the connector.
- FulfillmentId supports the '=,IN' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM FulfillmentEvents
SELECT * FROM FulfillmentEvents WHERE FulfillmentId = 'Val1'
Insert
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. |