ReturnLineItems
Retrieves the return line items attached to the return.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.
- ReturnId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
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. |