JDBC Driver for Stripe

Build 22.0.8462

BankAccountTokens

Create and query the available Bank Account Tokens in Stripe.

Table Specific Information

Select

Server-Side Query Support

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

  • Id 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, Currency, and AccountNumber are required:

INSERT INTO BankAccountTokens  (Country, Currency, AccountHolderName, AccountHolderType, AccountNumber, RoutingNumber)  VALUES ('US' ,'USD' ,'Sab nu' , 'individual' ,'000123456789','110000000') 

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The Id of the token.

BankAccountId String False

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 False

Name of the bank associated with the routing number.

Fingerprint String False

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 False

The IP address of the client that generated the token.

Created Datetime True

The datetime of the token.

Used Boolean False

Whether or not this token has already been used.

LiveMode Boolean False

Has the value true if the object exists in live mode or the value false if the object exists in test mode.

Type String False

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462