Cards
Create, update, delete and query the available Cards in Stripe.
Table Specific Information
This is a deprecated object. Use PaymentMethods table instead of Cards table.
Select
Server-Side Query Support
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 and CustomerId support the following operator: =.
To query Cards table, CustomerId is required:
SELECT * FROM Cards WHERE CustomerId='cus_12345678'
In addition to CustomerId, 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 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' )
Update
To update a Card, specify both 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 for a Customer, specify both Id and CustomerId:
DELETE FROM Cards WHERE Id = 'ca_12345678' AND CustomerId = 'cus_123456778'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | False |
The card Id. | |
| CustomerId [KEY] | String | False |
The customer Id this card belongs to. | |
| ExpMonth | Integer | False |
The card expire month. | |
| ExpYear | Integer | False |
The card expire 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 | False |
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 | False |
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 | False |
If AddressZip was provided. Possible values: pass, fail, unavailable, or unchecked. | |
| Brand | String | False |
Card brand. | |
| Country | String | False |
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 | False |
If a CVC was provided. Possible values: pass, fail, unavailable, or unchecked. | |
| 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 expire year. | |
| Fingerprint | String | False |
Uniquely identifies this particular card number. | |
| Funding | String | False |
Card funding type. | |
| Last4 | String | True |
Last 4 digits of the card. | |
| Name | String | False |
Cardholder name. | |
| Recipient | String | False |
The recipient that this card belongs to. | |
| TokenizationMethod | String | False |
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. |