JDBC Driver for Stripe

Build 22.0.8462

PaymentMethods

Create, update and query the available PaymentMethods in Stripe.

Table Specific Information

Select

The driver will use 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 driver.

  • Id support the following operator: =.
  • CustomerId support the following operator: =.
  • Type support the following operator: =.
  • AccountId support the following operator: =.

The provider supports all columns to be used as criteria in the WHERE clause of SELECT statement, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retrieve the PaymentMethods: 

SELECT * FROM PaymentMethods WHERE Id = 'src_1MTIO2SC4snQ4WkOadEObFqk'
SELECT * FROM PaymentMethods WHERE CustomerId = 'cus_N8rO0qc7j1SJJ9'
SELECT * FROM PaymentMethods WHERE CustomerId = 'cus_N8rO0qc7j1SJJ9' AND Type = 'card'
SELECT * FROM PaymentMethods WHERE CustomerId = 'cus_N8rO0qc7j1SJJ9' AND AccountId = 'acct_1MGcyqSC4snQ4WkO'

Insert

To create a new PaymentMethod, at least Type is required: 

INSERT INTO PaymentMethods (Type) VALUES ('affirm')
INSERT INTO PaymentMethods (Type, CardExpMonth, CardExpYear,CardNumber, CardCVC, BillingDetailsAddressCity, BillingDetailsAddressCountry, BillingDetailsAddressLine1, BillingDetailsAddressLine2, BillingDetailsAddressPostalCode, BillingDetailsAddressState, BillingDetailsEmail, BillingDetailsName, BillingDetailsPhone) Values ('card', '11', '24', '4242424242424242', '531', 'Bengaluru', 'IN', 'Neeladri', 'Ecity', '5601001', 'Karnataka', '[email protected]', 'YOEGSH MANGAL', '7728062870')

Update

To modify a PaymentMethod, specify the PaymentMethods Id and run an Update statement. 

UPDATE PaymentMethods SET BillingDetailsAddressCity = 'Jaipur' WHERE Id = 'src_1MSDXZSC4snQ4WkOUER8uzmc'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The Id of the Payment Method.

CustomerId String True

The Id of the Customer.

BillingDetailsAddressCity String False

City, district, suburb, town, or village name for Billing Address.

BillingDetailsAddressCountry String False

2-letter country code for Billing Address.

BillingDetailsAddressLine1 String False

Address line 1 for Billing Address.

BillingDetailsAddressLine2 String False

Address line 2 for Billing Address.

BillingDetailsAddressPostalCode String False

ZIP or postal code for Billing Address.

BillingDetailsAddressState String False

State, county, province, or region for Billing Address.

BillingDetailsEmail String False

Email address for Billing Address.

BillingDetailsName String False

Full name for Billing Address.

BillingDetailsPhone String False

Billing phone number (including extension).

CardBrand String True

Card brand. Can be amex, diners, discover, jcb, mastercard, unionpay, visa, or unknown.

CardChecksAddressLine1Check String True

If a address line1 was provided, results of the check, one of pass, fail, unavailable, or unchecked.

CardChecksAddressPostalCodeCheck String True

If a address postal code was provided, results of the check, one of pass, fail, unavailable, or unchecked.

CardChecksCvcCheck String True

If a CVC was provided, results of the check, one of pass, fail, unavailable, or unchecked.

CardCountry String True

Two-letter ISO code representing the country of the card.

CardExpMonth Integer False

Two-digit number representing the card expiration month.

CardExpYear Integer False

Four-digit number representing the card expiration year.

CardFingerprint String True

Uniquely identifies this particular card number.

CardFunding String True

Card funding type. Can be credit, debit, prepaid, or unknown.

CardGeneratedFrom String True

Details of the original PaymentMethod that created this object.

CardLast4 String True

The last four digits of the card.

CardNetworksAvailable String True

All available networks for the card.

CardNetworksPreferred String True

The preferred network for the card.

CardThreeDSecureUsageSupported Boolean True

Whether 3D Secure is supported on this card.

CardWallet String True

If this Card is part of a card wallet, this contains the details of the card wallet.

AcssDebitBankName String False

Bank name for the payment method type acss_debit.

AcssDebitInstitutionNumber String False

Institution number of the customer bank.

AcssDebitTransitNumber String False

Transit number of the customer bank.

AcssDebitFingerprint String True

Uniquely identifies this particular bank account for the payment method type acss_debit.

AcssDebitLast4 String True

Last four digits of the bank account number for the payment method type acss_debit.

AuBecsDebitFingerprint String True

Uniquely identifies this particular bank account for the payment method type au_becs_debit.

AuBecsDebitLast4 String True

Last four digits of the bank account number for the payment method type au_becs_debit.

BacsDebitSortCode String False

Sort code of the bank account(e.g., 10-20-30). for the payment method type bacs_debit.

BacsDebitLast4 String True

Uniquely identifies this particular bank account for the payment method type bacs_debit.

BacsDebitFingerprint String True

Last four digits of the bank account number for the payment method type bacs_debit.

EpsBank String False

The customer bank. EPS is an Austria-based bank redirect payment method.

FpxAccountHolderType String True

Account holder type for FPX bank. FPX is a Malaysia-based bank redirect payment method.

FpxBank String False

The customer bank name and it should be Malaysia-based bank.

IdealBank String False

The customer bank name and it is a Netherlands-based bank redirect payment method.

IdealBic String True

Bank Identifier code for Ideal Bank.

P24Bank String False

The customer bank. P24 stands for Przelewy24 is a bank redirect payment method used in Poland.

SepaDebitBankCode String True

Bank Code for SepaDebit.

SepaDebitBranchCode String True

Branch Code for SepaDebit.

SepaDebitCountry String True

Country for SepaDebit.

SepaDebitFingerprint String True

Fingerprint for SepaDebit.

SepaDebitGeneratedFromCharge String True

SepaDebit generated from Charge.

SepaDebitGeneratedFromSetupAttempt String True

SepaDebit generated from setup attempt.

SepaDebitLast4 String True

Last 4 digits of IBAN of the Bank Account.

SofortCountry String False

Two-letter ISO code representing the country the bank account is located in. Sofort is a bank redirect payment method used in Europe.

UsBankAccountAccountHolderType String False

Account holder type: individual or company.

UsBankAccountAccountType String False

Account type: checkings or savings. Defaults to checking if omitted.

UsBankAccountBankName String True

Bank name.

UsBankAccountFinancialConnectionsAccount String True

The ID of a Financial Connections Account to use as a payment method.

UsBankAccountFingerprint String True

Fingerprint of UsBank Account.

UsBankAccountLast4 String True

Last4 digits of the UsBank Account number.

UsBankAccountRoutingNumber String False

Routing number of the bank account.

Created Timestamp True

Time at which the object was created.

Livemode Boolean True

Has the value true if the object exists in live mode or the value false if the object exists in test mode.

MetadataOrderId String True

MetaData order Id.

Object String True

String representing the object type. Objects of the same type share the same value.

Type String False

The type of the PaymentMethod. The type of PaymentMethods supported are: acss_debit, affirm, afterpay_clearpay, alipay, au_becs_debit, bacs_debit, bancontact, blik, boleto, card, customer_balance, eps, fps, giropay, grabpay, ideal, klarna, konbini, oxxo, p24, paynow, pix, promptpay, sepa_debit, sofort, us_bank_account, wechat_pay.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
CardNumber String

Card Number.

CardCVC String

Card CVC number.

AcssDebitAccountNumber String

Customer bank account number. Pre-authorized debit payments are used to debit Canadian bank accounts through the Automated Clearing Settlement System (ACSS).

AuBecsDebitAccountNumber String

The account number for the bank account. BECS Direct Debit is used to debit Australian bank accounts through the Bulk Electronic Clearing System (BECS).

AuBecsDebitBsbNumber String

Bank-State-Branch number of the bank account.

BacsDebitAccountNumber String

Account number of the bank account that the funds will be debited from. Bacs Direct Debit is used to debit UK bank accounts.

BoletoTaxId String

The tax ID of the customer. Boleto is a voucher-based payment method used in Brazil.

KlarnaDobDay String

The day of birth, between 1 and 31 of Customer for paymentmethod type klarna.

KlarnaDobMonth String

The month of birth, between 1 and 12 of Customer for paymentmethod type klarna.

KlarnaDobYear String

The four-digit year of birth of Customer for paymentmethod type klarna.

SepaDebitIban String

IBAN of the bank account. SEPA Direct Debit is used to debit bank accounts within the Single Euro Payments Area (SEPA) region.

UsBankAccountAccountNumber String

Account number of the bank account. ACH Direct Debit is used to debit US bank accounts through the Automated Clearing House (ACH) payments system.

AccountId String

The Id of the connected account.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462