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 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'

In addition to the CustomerId, Stripe supports the use of all columns in the WHERE clause of a SELECT statement, if SupportEnhancedSQL is set to True. If you set the SupportEnhancedSQL property to False, you can still retrieve a Card by specifying its Id:

SELECT * FROM Cards WHERE CustomerId = 'cus_12345678' AND Id = 'ca_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.
Recipient	String	True		The recipient that this card belongs to.
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.

Pseudo-Columns

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


Name	Type	Description
AccountId	String	The Id of the connected account to get cards for.

JDBC Driver for Stripe