Query order shipping.

View-Specific Information

Select

The driver 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 driver processes other filters client-side within the driver. For example, the following queries are processed server side.

SELECT * FROM ShippingItems

SELECT * FROM ShippingItems WHERE OrderId='123'

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

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

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.