Returns
Retrieves a list of returns for the order.
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operator. 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
Insert statements are mapped to the 'returnCreate' GraphQL mutation.
The following columns can be used to create a new record:
OrdersId
The following pseudo-columns 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. |