CardTokens

Returns the card tokens in Stripe, which represent a card in a way that can be securely shared and used to create payment sources.

Table-Specific Information

SELECT

The provider uses 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 provider.


Column	Supported Operators
Id	=
AccountId	=

To query the CardTokens table, the Id of desired token is required:

SELECT * FROM CardTokens WHERE Id = 'tok_12345678'

SELECT * FROM CardTokens WHERE Id = 'tok_12345678' AND AccountId = 'acct_1TjaVhHcQfMnD4eS'

INSERT

The ExpMonth, ExpYear, and Number are required to insert a new card token.

INSERT INTO CardTokens (ExpMonth, ExpYear, Number) VALUES (11, 2018, 4242424242424242)

INSERT INTO CardTokens (AddressCity, AddressCountry, AddressLine1, AddressLine2, AddressZip, Currency, ExpMonth, ExpYear, Name, Number, AddressState) VALUES ('Mohali', 'INDIA', 'TestAddressLine1', 'TestAddressLine2', 123456, 'inr', '01', '2029', 'Tapan Sharma', '4242424242424242', 'Punjab')

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The Id of the token.
CardId	String	True	Cards.Id	The Id of the card, used in conjunction with a customer or recipient Id.
AddressCity	String	False		The city of the billing address for the card.
AddressCountry	String	False		The country of the billing address for the card.
AddressLine1	String	False		The first line of the billing address for the card.
AddressLine1Check	String	True		The result of checking the address_line1, if it was provided.
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 the address_zip, if it was provided.
Brand	String	True		The brand of the card.
Country	String	True		The two-letter ISO code representing the country in which the card was issued.
Currency	String	False		The currency of the card.
CvcCheck	String	True		The result of checking the CVC, if it was provided.
DynamicLast4	String	True		The last four digits of the device account number.
ExpMonth	Integer	False		The expiration month of the card.
ExpYear	Integer	False		The expiration year of the card.
Last4	String	True		The last 4 digits of the card number.
Fingerprint	String	True		A unique identifier for the card, which you can use to check whether two cards are the same.
Funding	String	True		The funding type of the card.
Name	String	False		The cardholder name.
MetadataAggregate	String	True		The card metadata object.
TokenizationMethod	String	True		If the card number is tokenized, this is the method that was used.
ClientIp	String	True		The IP address of the client that generated the token.
Created	Datetime	True		The date and time at which the token was created.
Used	Boolean	True		Indicates whether this token has already been used.
Number	String	False		The card number.
LiveMode	Boolean	True		Indicates whether the object exists in live mode. Returns false if the object exists in test mode.
Type	String	True		The type of the token.

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.