CardTokens
Create and query the available Card Tokens in Stripe.
Table Specific Information
Select
Server-Side Query Support
The connector 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 connector.
- Id supports the following operator: =.
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')
Update
UPDATE is not supported.
Delete
Delete is not supported.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The Id of the token. | |
| CardId | String | True |
The Id of 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 |
Last4. | |
| Fingerprint | String | True |
Uniquely 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 datetime of the token. | |
| Used | Boolean | True |
Whether or not this token has already been used. | |
| Number | String | False |
The card number. | |
| LiveMode | Boolean | True |
Has the value true if the object exists in live mode or the value false if the object exists in test mode. | |
| Type | String | True |
Type of token. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| CustomerId | String |
The Id of the customer to create a token for. |
| AccountId | String |
The Id of the connected account to get card tokens for. |