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.