ShopifyPaymentsAccountDisputes
Lists disputes associated with the Shopify Payments account.
View-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.
- Id supports the '=, !=' comparison operators.
- Status supports the '=, !=' comparison operators.
- InitiatedAt supports the '=, !=, <, >, >=, <=' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM ShopifyPaymentsAccountDisputes WHERE Id = 'Val1'
SELECT * FROM ShopifyPaymentsAccountDisputes WHERE Status = 'Val1'
SELECT * FROM ShopifyPaymentsAccountDisputes WHERE InitiatedAt = '2023-01-01 11:10:00'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique Id for the dispute. | |
| LegacyResourceId | String | The Id of the corresponding resource in the REST Admin API. | |
| ShopifyPaymentsAccountId | String | A globally unique Id for the associated Shopify Payments account. | |
| EvidenceDueBy | Date | The deadline date for submitting evidence. | |
| EvidenceSentOn | Date | The date when evidence was submitted. Returns null if evidence has not yet been sent. | |
| Status | String | The current status of the dispute, such as under_review or accepted. | |
| Type | String | Indicates whether the dispute is in the inquiry phase or has become a chargeback. | |
| FinalizedOn | Date | The date when the dispute was resolved. Returns null if the dispute is not yet finalized. | |
| InitiatedAt | Datetime | The date and time when the dispute was initiated. | |
| AmountAmount | Decimal | The disputed amount, expressed as a decimal value. | |
| AmountCurrencyCode | String | The currency code of the disputed amount. | |
| OrderId | String | A globally unique Id for the associated order. | |
| ReasonDetailsReason | String | The reason for the dispute provided by the cardholder's bank. | |
| ReasonDetailsNetworkReasonCode | String | The raw reason code provided by the payment network. |