Query order shipping.

View-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the OrderId and OrderUpdatedAt columns. The supported SQL operators are '=' for OrderId and '>' and '<' for OrderUpdatedAt. The connector processes other filters client-side within the connector. For example, the following queries are processed server-side.

SELECT * FROM ShippingItems WHERE OrderId = '123'

SELECT * FROM ShippingItems WHERE OrderUpdatedAt > '2018-05-05'

Columns

Name	Type	References	Description
Id [KEY]	Long		The id of the shipping item.
OrderId [KEY]	Long	Orders.Id	The id of the order.
OrderUpdatedAt	Datetime		The date and time when the order was last modified.
Price	Decimal		The price of this shipping method.
Code	String		A reference to the shipping method.
Title	String		The title of the shipping method.
Source	String		The source of the shipping method.
CarrierIdentifier	String		A reference to the carrier service that provided the rate.
RequestedFulfillmentServiceId	String		A reference to the fulfillment service that is being requested for the shipping method.