ODBC Driver for Stripe

Build 24.0.9062

Disputes

Query the available Disputes in Stripe.

Table Specific Information

Select

Server-Side Query Support

The 本製品 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 本製品.

  • 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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062