CData Python Connector for Shopify

Build 23.0.8839

FulfillmentEvents

Create, delete, and query information regarding fulfillment events.

Table-Specific Information

Select

The OrderId and FulfillmentId are required to query this table. The connector uses the Shopify API to process search criteria that refer to the OrderId, FulfillmentId, and Id columns. The supported SQL operator is '='. The connector processes other filters client-side within the connector.

For example, the following queries are processed server-side:

SELECT * FROM FulfillmentEvents WHERE OrderId = '123' AND FulfillmentId = '456'

SELECT * FROM FulfillmentEvents WHERE OrderId = '123' AND FulfillmentId = '456' AND Id = '789'

Insert

You must specify the OrderId, FulfillmentId, and Status to create a fulfillment event.

INSERT INTO FulfillmentEvents (Orderid, FulfillmentId, Status, Message, EstimatedDeliveryAt) VALUES ('202520330263', '206541914135', 'in_transit', 'test', '2018-08-02 10:15:25 PM')

Delete

You must specify the OrderId, FulfillmentId, and Id of the fulfillment event to delete it.

DELETE FROM FulfillmentEvents WHERE Orderid = '202520330263' AND FulfillmentId = '206541914135' AND Id = '2374424264727'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

A numeric unique identifier for the fulfillment event.

OrderId [KEY] Long False

Orders.Id

The id of the order the fulfillment event belongs to.

FulfillmentId [KEY] Long False

Fulfillments.Id

A numeric unique identifier for the fulfillment to which the fulfillment event belongs.

ShopId Long True

Shop.Id

A numeric unique identifier for the shop to which the fulfillment event belongs.

Status String False

The status of the fulfillment event. Valid values are: confirmed, in_transit, out_for_delivery, delivered, failure.

EstimatedDeliveryAt Datetime False

The status of the fulfillment event. Valid values are: confirmed, in_transit, out_for_delivery, delivered, failure.

Message String False

An arbitrary message describing the status. Can be provided by a shipping carrier.

City String False

The city in which the fulfillment event occurred.

Province String False

The province in which the fulfillment event occurred.

Zip String False

The zip code in the location in which the fulfillment event occurred.

Country String False

The country in which the fulfillment event occurred.

Address1 String False

The fulfillment event's street address.

Latitude Double False

Geographic coordinate specifying the north/south location of a fulfillment event.

Longitude Double False

Geographic coordinate specifying the east/west location of a fulfillment event.

CreatedAt Datetime True

The date and time when the fulfillment event was created.

UpdatedAt Datetime True

The date and time when the fulfillment event was updated.

HappenedAt Datetime True

The date and time when the fulfillment event occurred.

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