Create and query the available Card Tokens in Stripe.
Table Specific Information
Server-Side Query Support
The connector 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 connector.
- Id support the following operators:=.
To query CardTokens table, the Id of desired token is required:
SELECT * FROM CardTokens WHERE Id='tok_12345678'
The ExpMonth, ExpYear, and Number are required to insert a new Card Token.
INSERT INTO CardTokens (ExpMonth, ExpYear, Number) VALUES (11, 2018, 4242424242424242)
Update is not supported.
Delete is not supported.
The Id of the token.
The Id of card (used in conjunction with a customer or recipient Id)
The city address of the card.
The country address of the card.
The address line 1.
If address_line1 was provided.
The address line 2.
The address state.
The zip address.
If address_zip was provided.
The card brand.
Two-letter ISO code representing the country the bank account/card is located in.
The currency of the card.
If a CVC was provided.
The last four digits of the device account number.
The card expiration month.
The card expiration year.
Card funding type.
If the card number is tokenized, this is the method that was used.
The IP address of the client that generated the token.
The datetime of the token.
Whether or not this token has already been used.
The card number.
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.
The Id of the customer to create a token for.
The Id of the connected account to get card tokens for.