Returns
Retrieves a list of returns for the order.
Table-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.
- OrdersId supports the '=,IN' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM Returns
SELECT * FROM Returns WHERE OrdersId = 'Val1'
Insert
The following column can be used to create a new record:
OrdersId
The following pseudo-column can be used to create a new record:
ReturnLineItems
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
A globally-unique ID. | |
OrdersId | String | True |
Orders.Id |
A globally-unique ID. |
Name | String | True |
The name of the return. | |
Status | String | True |
The status of the return. | |
TotalQuantity | Int | True |
The sum of all line item quantities for the return. | |
DeclineReason | String | True |
The reason the customer's return request was declined. | |
DeclineNote | String | True |
The notification message sent to the customer about their declined return request. Maximum length: 500 characters. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements, to offer a more granular control over the tuples that are returned from the data source, or as parameters in INSERT statements.
Name | Type | Description |
ReturnLineItems | String |
The list of the line items in the return. |