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 Id column, which supports the '=' comparison operators.
The connector processes other filters client-side within the connector.
For example, the following queries are processed server-side:
SELECT * FROM ReturnLineItems WHERE ReturnId='VALUE'
Insert
INSERT statements are mapped to the 'priceListCreate' GraphQL mutation.
The following columns can be used to create a new record:
Quantity, ReturnReason, ReturnReasonNote, FulfillmentLineItemId
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. |