CardTokens

Returns the available Card Tokens in Stripe and supports creating them.

Table-Specific Information

SELECT

The driver 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 driver.


Column	Supported Operators
Id	=

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

SELECT * FROM CardTokens WHERE Id = 'tok_12345678'

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		The Id of the card (used in conjunction with a customer or recipient Id).
AddressCity	String	False		The city address of the card.
AddressCountry	String	False		The country address of the card.
AddressLine1	String	False		The address line 1.
AddressLine1Check	String	True		If address_line1 was provided.
AddressLine2	String	False		The address line 2.
AddressState	String	False		The address state.
AddressZip	String	False		The zip address.
AddressZipCheck	String	True		If address_zip was provided.
Brand	String	True		The card brand.
Country	String	True		Two-letter ISO code representing the country the bank account/card is located in.
Currency	String	False		The currency of the card.
CvcCheck	String	True		If a CVC was provided.
DynamicLast4	String	True		The last four digits of the device account number.
ExpMonth	Integer	False		The card expiration month.
ExpYear	Integer	False		The card expiration year.
Last4	String	True		The last 4 digits of the card.
Fingerprint	String	True		A unique identifier.
Funding	String	True		Card funding type.
Name	String	False		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 of the token.
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. The value is true in live mode and false in test mode.
Type	String	True		Type of 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.