CData Python Connector for Shopify

Build 23.0.8839

ShippingItems

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.

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