Disputes

Returns payment disputes, including evidence, dispute reason, and resolution status details.

Table-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	=, >, >=, <, <=
AccountId	=
PaymentIntent	=
Charge	=

You can select:

A dispute by specifying its Id:

SELECT * FROM Disputes WHERE Id = 'dp_12345678'

Disputes opened after a specific date:

SELECT * FROM Disputes WHERE Created > '2018-01-01'

Created can also be used twice to specify a range:

SELECT * FROM Disputes WHERE Created >= '2018-01-01 00:00:00.0' AND Created <= '2018-12-31 23:59:59.0'

UPDATE

To modify a dispute, specify the dispute Id:

UPDATE Disputes SET EvidenceCustomerName = 'Test User' WHERE Id = 'dp_12345678'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The Id of the dispute.
Currency	String	True		The three-letter ISO currency code representing the currency of the disputed amount.
EvidenceAccessActivityLog	String	False		Any server or activity logs showing proof that the customer accessed or downloaded the purchased digital product.
EvidenceBillingAddress	String	False		The billing address provided by the customer.
EvidenceCancellationPolicy	String	False		Your subscription cancellation policy, as shown to the customer.
EvidenceCancellationPolicyDisclosure	String	False		An explanation of how and when the customer was shown your refund policy prior to purchase.
EvidenceCancellationRebuttal	String	False		A justification for why the customer's subscription was not canceled.
EvidenceCustomerCommunication	String	False		The Id of a file upload containing any communication with the customer that is relevant to the case, such as emails proving that they received the product or service or demonstrating their use of or satisfaction with the product or service.
EvidenceCustomerEmailAddress	String	False		The email address of the customer.
EvidenceCustomerName	String	False		The name of the customer.
EvidenceCustomerPurchaseIp	String	False		The IP address that the customer used when making the purchase.
EvidenceCustomerSignature	String	False		The Id of a file upload containing a relevant document or contract that shows the customer's signature.
EvidenceDuplicateChargeDocumentation	String	False		The Id of a file upload containing documentation for the prior charge that can uniquely identify it, such as a receipt, shipping label, or work order.
EvidenceDuplicateChargeExplanation	String	False		The explanation of the difference between the disputed charge and the prior charge that appears to be a duplicate.
EvidenceDuplicateChargeId	String	False		The Stripe Id for the prior charge that appears to be a duplicate of the disputed charge.
EvidenceProductDescription	String	False		The description of the product or service that was sold.
EvidenceReceipt	String	False		The Id of a file upload containing any receipt or message sent to the customer notifying them of the charge.
EvidenceRefundPolicy	String	False		The Id of a file upload containing your refund policy, as shown to the customer.
EvidenceRefundPolicyDisclosure	String	False		The documentation demonstrating that the customer was shown your refund policy prior to purchase.
EvidenceRefundRefusalExplanation	String	False		The justification for why the customer is not entitled to a refund.
EvidenceServiceDate	String	False		The date on which the customer received or began receiving the purchased service, in a clear human-readable format.
EvidenceServiceDocumentation	String	False		The Id of a file upload containing documentation that proves a service was provided to the customer, such as a copy of a signed contract, work order, or other form of written agreement.
EvidenceShippingAddress	String	False		The address to which a physical product was shipped. Include as much complete address information as possible.
EvidenceShippingCarrier	String	False		The delivery service that shipped a physical product, such as FedEx, UPS, or USPS. If multiple carriers were used for this purchase, separate them with commas.
EvidenceShippingDate	String	False		The date on which a physical product began its route to the shipping address, in a clear human-readable format.
EvidenceShippingDocumentation	String	False		The Id of a file upload containing documentation that proves a product was shipped to the customer at the same address the customer provided, such as a copy of the shipment receipt or shipping label. It should show the full shipping address of the customer, if possible.
EvidenceShippingTrackingNumber	String	False		The tracking number for a physical product, obtained from the delivery service. If multiple tracking numbers were generated for this purchase, separate them with commas.
EvidenceUncategorizedFile	String	False		The Id of a file upload containing any additional evidence or statements.
EvidenceUncategorizedText	String	False		Any additional evidence or statements.
EvidenceDetailsDueBy	Datetime	True		The date by which evidence must be submitted in order to successfully challenge the dispute.
EvidenceDetailsHasEvidence	Boolean	True		Indicates whether evidence has been saved for this dispute.
EvidenceDetailsPastDue	Boolean	True		Indicates whether the last evidence submission was submitted past the due date.
EvidenceDetailsSubmissionCount	Integer	True		The number of times the evidence has been submitted.
Amount	Integer	False		The amount that was disputed.
BalanceTransactionsAggregate	String	True		The list of zero, one, or two balance transactions that show funds withdrawn from and reinstated to your Stripe account as a result of this dispute.
Charge	String	True	Charges.Id	The Id of the charge that was disputed.
Created	Datetime	True		The date the dispute was opened.
IsChargeRefundable	Boolean	True		Indicates whether it is still possible to refund the disputed payment.
Livemode	Boolean	True		Indicates whether the dispute is in live mode.
Reason	String	True		The reason given by the cardholder for the dispute.
Status	String	True		The current status of the dispute.
MetadataAggregate	String	False		The set of key-value pairs that you can attach to an object. This is useful for storing additional information about the object in a structured format.
Object	String	True		The string representing the object's type. Objects of the same type share the same value.
PaymentIntent	String	True	PaymentIntent.Id	The Id of the payment intent that was disputed.
PaymentMethodDetails	String	True		Additional dispute information specific to the payment method type.
PreventionsEnhancedEvidenceFlowStatus	String	True		DEPRECATED. Status of the enhanced evidence flow for this dispute prevention.
PaymentMethodDetailsType	String	True		Payment method type that was used for the disputed charge.
PaymentMethodDetailsCard	String	True		Card-specific details about the disputed payment.

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.