Disputes

Query the available Disputes in Stripe.

Table Specific Information

Select

Server-Side Query Support

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.

Id support the following operators: =.
Created support the following operators: <,>>=,<,<=,=.
AccountId support the following operators: =.
PAymentIntent support the following operators: =.
Charge support the following operators: =.

You can select:

A dispute by specifying its Id:

SELECT * FROM Disputes WHERE Id = 'dp_12345678'

Disputes opened after a specific date (Created may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range):

SELECT * FROM Disputes WHERE Created > '2016-01-03'

Insert

INSERT is not supported.

Update

To modify a dispute, specify the dispute Id:

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

Delete

Delete is not supported.

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The Id of the dispute.
Currency	String	True		Three-letter ISO currency code representing the currency of the amount that was disputed.
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) Any communication with the customer that you feel is relevant to your case (for example 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) A relevant document or contract showing the customer's signature.
EvidenceDuplicateChargeDocumentation	String	False		The (ID of a file upload) Documentation for the prior charge that can uniquely identify the charge, such as a receipt, shipping label, work order, etc.
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 which appears to be a duplicate of the disputed charge.
EvidenceProductDescription	String	False		The description of the product or service which was sold.
EvidenceReceipt	String	False		The (ID of a file upload) Any receipt or message sent to the customer notifying them of the charge.
EvidenceRefundPolicy	String	False		The (ID of a file upload) 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) Documentation showing proof that a service was provided to the customer. This could include 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. You should try to include as much complete address information as possible.
EvidenceShippingCarrier	String	False		The delivery service that shipped a physical product, such as Fedex, UPS, USPS, etc. If multiple carriers were used for this purchase, please 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) Documentation showing proof that a product was shipped to the customer at the same address the customer provided to you. This could include a copy of the shipment receipt, shipping label, etc, and 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, please separate them with commas.
EvidenceUncategorizedFile	String	False		The (ID of a file upload) Any additional evidence or statements.
EvidenceUncategorizedText	String	False		Any additional evidence or statements.
EvidenceDetailsDueBy	Datetime	True		Date by which evidence must be submitted in order to successfully challenge dispute.
EvidenceDetailsHasEvidence	Boolean	True		Whether or not evidence has been saved for this dispute.
EvidenceDetailsPastDue	Boolean	True		Whether or not the last evidence submission was submitted past.
EvidenceDetailsSubmissionCount	Integer	True		The number of times the evidence has been submitted.
Amount	Integer	True		The disputed amount.
BalanceTransactionsAggregate	String	True		List of zero, one, or two balance transactions that show funds withdrawn and reinstated to your Stripe account as a result of this dispute.
Charge	String	True		The Id of the charge that was disputed.
Created	Datetime	True		The Date dispute was opened.
IsChargeRefundable	Boolean	True		If true, it is still possible to refund the disputed payment.
Livemode	Boolean	True		Tells if the dispute is in livemode.
Reason	String	True		The reason given by cardholder for dispute.
Status	String	True		The current status of dispute.
MetadataAggregate	String	False		Set of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format.
Transaction	String	True		The transaction being disputed.
Object	String	True		String representing the object's type. Objects of the same type share the same value.
PaymentIntent	String	True		ID of the PaymentIntent that was disputed.
PaymentMethodDetails	String	True		Additional dispute information specific to the payment method type.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
AccountId	String	The Id of the connected account to get disputes for.
Submit	Boolean	Whether to immediately submit evidence to the bank. If false, evidence is staged on the dispute. Staged evidence is visible in the API and Dashboard, and can be submitted to the bank by making another request with this attribute set to true

Tableau Connector for Stripe