ODBC Driver for Shopify

Build 24.0.9060

OrderAdditionalFees

A list of additional fees applied to the order.

View-Specific Information

Select

The driver uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The driver processes other filters client-side within the driver.

  • OrderId supports the '=' comparison operators.

For example, the following queries are processed server side:

  SELECT * FROM OrderAdditionalFees
  SELECT * FROM OrderAdditionalFees WHERE OrderId = 'Val1'

Columns

Name Type References Description
Id [KEY] String A globally-unique ID.
OrderId String

Orders.Id

A globally-unique ID.
Name String The name of the additional fee.
PricePresentmentMoneyAmount Decimal Decimal money amount.
PricePresentmentMoneyCurrencyCode String Currency of the money.
PriceShopMoneyAmount Decimal Decimal money amount.
PriceShopMoneyCurrencyCode String Currency of the money.

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