IssuingDisputes
Returns issuing disputes, including the disputed amount, evidence, status, and associated transaction details.
View-Specific Information
SELECT
The provider uses the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| Id | = |
| Created | =, >, >=, <, <= |
| Transaction | = |
| Status | = |
| AccountId | = |
You can select from IssuingDisputes with the following queries:
SELECT * FROM IssuingDisputes WHERE Id = 'id_1GhPzLJXTn'
SELECT * FROM IssuingDisputes WHERE Created >= '2024-01-01'
SELECT * FROM IssuingDisputes WHERE Transaction = 'txn_12345'
SELECT * FROM IssuingDisputes WHERE Status = 'expired'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The Id of the issuing dispute. | |
| Amount | Integer | The disputed amount in the card's currency and in the smallest currency unit, usually the amount of the transaction. | |
| BalanceTransactions | String | The list of balance transactions associated with the dispute. | |
| Currency | String | The currency in which the transaction was made. | |
| Created | Datetime | The time at which the object was created, measured in seconds since the Unix epoch. | |
| EvidenceCanceled | String | The evidence provided when the reason is canceled. | |
| EvidenceDuplicate | String | The evidence provided when the reason is duplicate. | |
| EvidenceFraudulent | String | The evidence provided when the reason is fraudulent. | |
| EvidenceMerchandiseNotAsDescribed | String | The evidence provided when the reason is merchandise_not_as_described. | |
| EvidenceNotReceived | String | The evidence provided when the reason is not_received. | |
| EvidenceOther | String | The evidence provided when the reason is other. | |
| EvidenceReason | String | The reason for filing the dispute. Its value matches the field containing the evidence. | |
| EvidenceServiceNotAsDescribed | String | The evidence provided when the reason is service_not_as_described. | |
| MetadataAggregate | String | The set of key-value pairs that you can attach to an object. | |
| Status | String | The current status of the dispute. | |
| Transaction | String | The Id of the transaction being disputed. | |
| Object | String | The string representing the object's type. Objects of the same type share the same value. | |
| Livemode | Boolean | Indicates whether the object exists in live mode, which is true in live mode and false in test mode. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| AccountId | String | The Id of the connected account from which to retrieve issuing disputes. |