SSIS Components for Shopify

Build 24.0.9060

ReturnLineItems

Retrieves the return line items attached to the return.

View-Specific Information

Select

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

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

For example, the following queries are processed server side:

  SELECT * FROM ReturnLineItems
  SELECT * FROM ReturnLineItems WHERE ReturnId = 'Val1'

Columns

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

Returns.Id

A globally-unique ID.
Quantity Int The quantity being returned.
CustomerNote String A note from the customer that describes the item to be returned. Maximum length: 300 characters.
RefundableQuantity Int The quantity that can be refunded.
RefundedQuantity Int The quantity that was refunded.
ReturnReason String The reason for returning the item.
ReturnReasonNote String Additional information about the reason for the return. Maximum length: 255 characters.
TotalWeightUnit String The unit of measurement for `value`.
TotalWeightValue Double The weight value using the unit system specified with `unit`.
WithCodeDiscountedTotalPriceSetPresentmentMoneyAmount Decimal Decimal money amount.
WithCodeDiscountedTotalPriceSetPresentmentMoneyCurrencyCode String Currency of the money.
WithCodeDiscountedTotalPriceSetShopMoneyAmount Decimal Decimal money amount.
WithCodeDiscountedTotalPriceSetShopMoneyCurrencyCode String Currency of the money.
FulfillmentLineItemId String A globally-unique ID.

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