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 SupportThe connector 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 connector.
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
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 |
| AccountId | String |
The Id of the connected account to get cards for. |