BankAccountTokens
Create and query the available Bank Account 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 and AccountId supports the following operator: =.
To query BankAccountTokens table, the Id of desired token is required:
SELECT * FROM BankAccountTokens WHERE Id = 'btok_12345678'
Insert
To insert into BankAccountTokens, Country, and AccountNumber are required:
INSERT INTO BankAccountTokens (Country, Currency, AccountHolderName, AccountHolderType, AccountNumber, RoutingNumber) VALUES ('US', 'USD', 'Sab nu', 'individual', '000123456789', '110000000')
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. | |
| BankAccountId | String | True |
The bank account this token will represent. | |
| AccountHolderName | String | False |
The name of the person or business that owns the bank account. | |
| AccountHolderType | String | False |
The type of entity that holds the account. | |
| AccountType | String | False |
The type of entity that holds the account type. | |
| AccountNumber | String | False |
The type of entity that holds the account number. | |
| BankName | String | True |
Name of the bank associated with the routing number. | |
| Fingerprint | String | True |
Uniquely identifier. | |
| Last4 | String | True |
The last 4 digits of the bank account number. | |
| RoutingNumber | String | False |
The routing transit number for the bank account. | |
| Status | String | True |
Status of the account. | |
| Country | String | False |
Two-letter ISO code representing the country the bank account/card is located in. | |
| Currency | String | False |
The currency of the card. | |
| 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. | |
| 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
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 |
| CustomerId | String |
The Id of the customer to create a token for. |
| AccountId | String |
The Id of the connected account to get bank account tokens for |