SSIS Components for Shopify

Build 25.0.9434

RefundLineItemDuties

Lists duties attached to refunded line items.

View-Specific Information

Select

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

  • RefundId supports the '=, IN' comparison operators.

For example, the following query is processed server-side:

  SELECT * FROM RefundLineItemDuties WHERE RefundId = 'Val1'

Columns

Name Type References Description
RefundId String A globally unique Id of the associated refund.
LineItemId String A globally unique Id of the line item.
Id [KEY] String A globally unique Id of the refund duty.
CountryCodeOfOrigin String The ISO 3166-1 alpha-2 country code of the item's country of origin used to calculate the duty.
HarmonizedSystemCode String The harmonized system code of the item used to calculate the duty.
PricePresentmentMoneyAmount Decimal The duty refund amount in the presentment currency, expressed as a decimal money amount.
PricePresentmentMoneyCurrencyCode String The currency code of the duty refund amount in the presentment currency.
PriceShopMoneyAmount Decimal The duty refund amount in the shop's currency, expressed as a decimal money amount.
PriceShopMoneyCurrencyCode String The currency code of the duty refund amount in the shop's currency.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434