CData Python Connector for Shopify

Build 23.0.8839

OrderDiscountCodes

Query note attributes belonging to an order or draft order.

View-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the OrderId and OrderUpdatedAt columns. The connector processes other filters client-side within the connector. For example, the following queries are processed server-side.
SELECT * FROM OrderDiscountCodes WHERE OrderId = '1'

SELECT * FROM OrderDiscountCodes WHERE OrderId IN ('1', '2')

SELECT * FROM OrderDiscountCodes WHERE OrderUpdatedAt <= '2019-05-13 09:23:06.0'

SELECT * FROM OrderDiscountCodes WHERE OrderUpdatedAt >= '2019-05-13 09:23:06.0'

Columns

Name Type References Description
OrderId [KEY] Long

Orders.Id

The id of the order.
OrderUpdatedAt Datetime The date and time when the order was last modified.
Code [KEY] String The name of the note attribute.
Amount String The value of the note attribute.
Type String The value of the note attribute.

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