JDBC Driver for Shopify

Build 23.0.8839

FulfillmentEvents

Retrieves the history of events associated with one or many fulfillments.

Table-Specific Information

Select

The 本製品 uses the Shopify API to process WHERE clause conditions built with the FulfillmentId column, which supports the '=' comparison operator.

The 本製品 processes other filters client-side within the 本製品.

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.

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