CData Python Connector for Shopify

Build 23.0.8839

RefundAdjustments

Create and query transactions.

Table-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the OrderId and RefundId column. The connector processes other filters client-side within the connector.

The Shopify APIs requires the search criteria to contain OrderId. For example, the following query is processed server-side.

SELECT * FROM RefundAdjustments WHERE OrderId = '123'
When performing a query without a filter or a filter other then the OrderId column, the connector will retrieve the entire list of refunds and perform the filters client-side. The Shopify API requires that an OrderId be specified when retrieving refunds. Therefore to retrieve all the refunds, the connector will first retrieve all the OrderIds from the Orders table (essentially performing the query: SELECT Id FROM Orders). Once the OrderId values have been retrieved, the connector will issue individual requests to the Shopify API to retrieve all the refunds for each OrderId to build the result set.
SELECT * FROM RefundAdjustments WHERE OrderId = '123' AND RefundId = '123'

Columns

Name Type References Description
Id [KEY] Long A unique numeric identifier for the refund adjustment.
OrderId Long

Orders.Id

The unique identifier for the order that the order adjustment is associated with.
RefundId Long

Refunds.Id

The unique identifier for the refund that the order adjustment is associated with.
Amount Decimal The value of the discrepancy between the calculated refund and the actual refund.
TaxAmount Decimal The taxes that are added to amount, such as applicable shipping taxes added to a shipping refund.
Kind String The order adjustment type.
Reason String The reason for the order adjustment.
AmountShopMoney Decimal The amount of the order adjustment in shop.
AmountShopCurrency String The currency of the order adjustment in shop.
AmountPresentmentMoney Decimal The amount of the order adjustment in presentment.
AmountPresentmentCurrency String The currency of the order adjustment in presentment.
TaxAmountShopMoney Decimal The tax amount of the order adjustment in shop.
TaxAmountShopCurrency String The tax currency of the order adjustment in shop.
TaxAmountPresentmentMoney Decimal The tax amount of the order adjustment in presentment.
TaxAmountPresentmentCurrency String The tax currency of the order adjustment in presentment.

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