Cards
Returns the cards attached to a customer in Stripe, including the card brand, expiration, billing address, and funding details.
Table-Specific Information
This table is deprecated. Use the PaymentMethods table instead.
SELECT
Server-Side Query SupportThe provider 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 provider.
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, AddressCountry) 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 unique identifier for the card. | |
| CustomerId [KEY] | String | False |
Customers.Id |
The Id of the customer this card belongs to. |
| ExpMonth | Integer | False |
The expiration month of the card. | |
| ExpYear | Integer | False |
The expiration year of the card. | |
| 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 |
Accounts.Id |
The Id of the account this card belongs to. |
| Token | String | False |
The Id of the token used to create the card. | |
| AddressCity | String | False |
The city of the billing address for the card. | |
| AddressCountry | String | False |
The country of the billing address, if provided when creating the card. | |
| AddressLine1 | String | False |
The first line of the billing address for the card. | |
| AddressLine1Check | String | True |
The result of checking AddressLine1, if it was provided. Possible values: pass, fail, unavailable, or unchecked. | |
| AddressLine2 | String | False |
The second line of the billing address for the card. | |
| AddressState | String | False |
The state of the billing address for the card. | |
| AddressZip | String | False |
The ZIP or postal code of the billing address for the card. | |
| AddressZipCheck | String | True |
The result of checking AddressZip, if it was provided. Possible values: pass, fail, unavailable, or unchecked. | |
| Brand | String | True |
The brand of the card. | |
| Country | String | True |
The two-letter ISO code representing the country of the card. You can use this attribute to get a sense of the international breakdown of cards you have collected. | |
| CvcCheck | String | True |
The result of checking the CVC, if it was provided. Possible values: pass, fail, unavailable, or unchecked. | |
| Cvc | String | False |
The card security code. It is highly recommended to always include this value, but it is required only for accounts based in European countries. | |
| DefaultForCurrency | Boolean | True |
DEPRECATED. Indicates whether this card is the default external account for its currency. Only applicable on accounts, not customers or recipients. | |
| Number | String | False |
The card number. | |
| Fingerprint | String | True |
A unique identifier for this particular card number, which you can use to check whether two cards are the same. | |
| Funding | String | True |
The funding type of the card. | |
| Last4 | String | True |
The last 4 digits of the card number. | |
| Name | String | False |
The cardholder name. | |
| TokenizationMethod | String | True |
If the card number is tokenized, this is the method that was used. | |
| Metadata | String | False |
The set of key-value pairs that you can attach to the object. This can be useful for storing additional information about the object in a structured format. | |
| Object | String | True |
The 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 |
The last four digits of the device account number, for tokenized numbers only. | |
| WalletApplePay | String | True |
If this is an apple_pay card wallet, contains details about the wallet. | |
| WalletType | String | True |
The type of the card wallet, such as apple_pay. An additional object is included on the wallet with a name matching this value, containing information specific to the card wallet type. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| AccountId | String |
The Id of the connected account for which to retrieve cards. |