CData Python Connector for Stripe

Build 23.0.8839


Create and query the available Bank Account Tokens in Stripe.

Table Specific Information


Server-Side Query Support

The 本製品 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 本製品.

  • 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'


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 is not supported.


Delete is not supported.


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.


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 bank account tokens for

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839