Refunds
Represents a refund of items or transactions in an 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.
- OrderId supports the '=,IN' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM Refunds
SELECT * FROM Refunds WHERE OrderId = 'Val1'
Insert
Insert statements are mapped to the 'refundCreate' GraphQL mutation.
The following columns can be used to create a new record:
OrderId, Note
The following pseudo-columns can be used to create a new record:
RefundLineItems
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Globally unique identifier. | |
| LegacyResourceId | String | True |
The ID of the corresponding resource in the REST Admin API. | |
| OrderId | String | True |
Orders.Id |
A globally-unique ID. |
| Note | String | True |
The optional note associated with the refund. | |
| CreatedAt | Datetime | True |
The date and time when the refund was created. | |
| UpdatedAt | Datetime | True |
The date and time when the refund was updated. | |
| ReturnId | String | True |
A globally-unique ID. | |
| StaffMemberId | String | True |
A globally-unique ID.(This column is available only with a ShopifyPlus subscription) | |
| TotalRefundedSetPresentmentMoneyAmount | Decimal | True |
Decimal money amount. | |
| TotalRefundedSetPresentmentMoneyCurrencyCode | String | True |
Currency of the money. | |
| TotalRefundedSetShopMoneyAmount | Decimal | True |
Decimal money amount. | |
| TotalRefundedSetShopMoneyCurrencyCode | String | True |
Currency of the money. |
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 |
| RefundLineItems | String |
The list of the line items in the draft order. |