Returns
Retrieves a list of returns for the order.
Table-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.
- 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 columns can be used to create a new record:
OrdersId, ReturnLineItems (references 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. | |
| ReturnLineItems | String | True |
The list of the line items in the return. |