JDBC Driver for Stripe

Build 24.0.9062

Cards

Create, update, delete and query the available Cards in Stripe.

Table Specific Information

This table is deprecated. Use the PaymentMethods table instead.

Select

Server-Side Query Support

The 本製品 uses the Stripe API to filter the results by Id, CustomerId and AccountId. They support the equals (=) operator.

The rest of the filter is executed client-side within the 本製品.

To query the Cards table, you must specify a CustomerId:

SELECT * FROM Cards WHERE CustomerId = 'cus_12345678'

Insert

You can insert a Card Token and then insert the Token Id to Cards:

INSERT INTO CardTokens (ExpMonth, ExpYear, Number) VALUES (11, 2018, 4242424242424242 )
INSERT INTO Cards (CustomerId, Token) VALUES ('cus_123456778', 'tok_1234345565' )
INSERT INTO Cards (CustomerId,ExpMonth,ExpYear,Number,Object,Country) VALUES ('cus_PARXAI77xUsWw1',6,'2025','4242424242424242','card','russia')

Update

To update a card, specify both the Id and CustomerId:

UPDATE Cards SET ExpMonth = '06', ExpYear = '2018', AddressCity = 'Houghton Street London' WHERE Id = 'ca_12345678' AND CustomerId = 'cus_123456778'

Delete

To delete a card, specify both the Id and CustomerId:

DELETE FROM Cards WHERE Id = 'ca_12345678' AND CustomerId = 'cus_123456778'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The card Id.

CustomerId [KEY] String False

The customer Id this card belongs to.

ExpMonth Integer False

The card expiry month.

ExpYear Integer False

The card expiry year.

Currency String False

Only applicable on accounts (not customers or recipients). The card can be used as a transfer destination for funds in this currency.

Account String True

The account Id this card belongs to.

Token String False

The token Id.

AddressCity String False

The city address.

AddressCountry String False

Billing address country, if provided when creating card.

AddressLine1 String False

The address line 1.

AddressLine1Check String True

If AddressLine1 was provided. Possible values: pass, fail, unavailable, or unchecked.

AddressLine2 String False

The address line 2.

AddressState String False

The address state.

AddressZip String False

The address ZIP.

AddressZipCheck String True

If AddressZip was provided. Possible values: pass, fail, unavailable, or unchecked.

Brand String True

Card brand.

Country String True

Two-letter ISO code representing the country of the card. You could use this attribute to get a sense of the international breakdown of cards you have collected.

CvcCheck String True

If a CVC was provided. Possible values: pass, fail, unavailable, or unchecked.

Cvc String False

Card security code. Highly recommended to always include this value, but it’s required only for accounts based in European countries.

DefaultForCurrency Boolean False

Only applicable on accounts (not customers or recipients). This indicates whether or not this card is the default external account for its currency.

Number String False

The card number.

Fingerprint String True

Uniquely identifies this particular card number.

Funding String True

Card funding type.

Last4 String True

Last 4 digits of the card.

Name String False

Cardholder name.

TokenizationMethod String True

If the card number is tokenized, this is the method that was used.

Metadata 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.

Object String False

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

AvailablePayoutMethods String True

A set of available payout methods for this card. Only values from this set should be passed as the method when creating a payout.

DynamicLast4 String True

(For tokenized numbers only.) The last four digits of the device account number.

WalletApplePay String True

If this is a apple_pay card wallet, this hash contains details about the wallet.

WalletType String True

The type of the card wallet, one of apple_pay. An additional hash is included on the Wallet subhash with a name matching this value. It contains additional information specific to the card wallet type.

Pseudo-Columns

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

Name Type Description
AccountId String

The Id of the connected account to get cards for.

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