CData Python Connector for Shopify

Build 23.0.8839

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 OrderIdcolumn, which supports the '=,IN' comparison operators.

The connector processes other filters client-side within the connector.

For example, the following query is processed server-side:

SELECT * FROM Fulfillments WHERE OrderId='VALUE'

Insert

INSERT statements are mapped to the 'fulfillmentCreateV2' GraphQL mutation.

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

OriginAddressAddress1, OriginAddressAddress2, OriginAddressCity, OriginAddressCountryCode, OriginAddressProvinceCode, OriginAddressZip, TrackingInfoNumber, TrackingInfoUrl, 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.

Name Type Description
FulfillmentOrderIds String

An aggregated object containing the FulfillmentOrder ids. Ex: [{'fulfillmentOrderId': 'gid://shopify/FulfillmentOrder/xxx'}]

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839