Fulfillments

Fulfillment represents a shipment of one or more items in an order.

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.

OrderId supports the '=,IN' comparison operators.

For example, the following queries are processed server side:

  SELECT * FROM Fulfillments
  SELECT * FROM Fulfillments WHERE OrderId = 'Val1'

Insert

The following columns can be used to create a new record:

Id, OriginAddressAddress1, OriginAddressAddress2, OriginAddressCity, OriginAddressCountryCode, OriginAddressProvinceCode, OriginAddressZip, TrackingInfoNumber, TrackingInfoUrl

The following pseudo-column can be used to create a new record:

FulfillmentOrderIds

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		A globally-unique ID.
LegacyResourceId	String	True		The ID of the corresponding resource in the REST Admin API.
OrderId	String	True		Globally unique identifier.
Name	String	True		Human readable reference identifier for this fulfillment.
Status	String	True		The status of the fulfillment.
DeliveredAt	Datetime	True		The date that this fulfillment was delivered.
DisplayStatus	String	True		Human readable display status for this fulfillment.
RequiresShipping	Bool	True		Whether any of the line items in the fulfillment require shipping.
TotalQuantity	Int	True		Sum of all line item quantities for the fulfillment.
EstimatedDeliveryAt	Datetime	True		The estimated date that this fulfillment will arrive.
InTransitAt	Datetime	True		The date and time when the fulfillment went into transit.
CreatedAt	Datetime	True		The date and time when the fulfillment was created.
UpdatedAt	Datetime	True		The date and time when the fulfillment was last modified.
LocationId	String	True		A globally-unique ID.
ServiceId	String	True		The ID of the fulfillment service.
OriginAddressAddress1	String	True		The street address of the fulfillment location.
OriginAddressAddress2	String	True		The second line of the address. Typically the number of the apartment, suite, or unit.
OriginAddressCity	String	True		The city in which the fulfillment location is located.
OriginAddressCountryCode	String	True		The country code of the fulfillment location.
OriginAddressProvinceCode	String	True		The province code of the fulfillment location.
OriginAddressZip	String	True		The zip code of the fulfillment location.
TrackingInfoNumber	String	True		TrackingInfoNumber
TrackingInfoUrl	String	True		TrackingInfoUrl

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements, to offer a more granular control over the tuples that are returned from the data source, or as parameters in INSERT statements.