IssuingDisputes
Returns a list of Issuing Dispute objects.
View-Specific Information
SELECT
The connector 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 connector.
| Column | Supported Operators |
| Id | = |
| Created | =, >, >=, <, <= |
| Transaction | = |
| Status | = |
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'
SELECT * FROM IssuingDisputes WHERE Currency = 'usd'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The Id of the dispute. | |
| Amount | Integer | Disputed amount in the card's currency and in the smallest currency unit. Usually the amount of the transaction. | |
| BalanceTransactions | String | List of balance transactions associated with the dispute. | |
| Currency | String | The currency the transaction was made in. | |
| Created | Datetime | The date and time at which the object was created, measured in seconds since the Unix epoch. | |
| EvidenceCanceled | String | Evidence provided when reason is canceled. | |
| EvidenceDuplicate | String | Evidence provided when reason is duplicate. | |
| EvidenceFraudulent | String | Evidence provided when reason is fraudulent. | |
| EvidenceMerchandiseNotAsDescribed | String | Evidence provided when reason is merchandise_not_as_described. | |
| EvidenceNotReceived | String | Evidence provided when reason is not_received. | |
| EvidenceOther | String | Evidence provided when reason is other. | |
| EvidenceReason | String | The reason for filing the dispute. Its value matches the field containing the evidence. | |
| EvidenceServiceNotAsDescribed | String | The service was not as described. | |
| MetadataAggregate | String | The set of key-value pairs that you can attach to an object. | |
| Status | String | Current status of the dispute. | |
| Transaction | String | The transaction being disputed. | |
| Object | String | The object type. | |
| Livemode | Boolean | Indicates whether the object exists in live mode. The value 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 account. |