BankAccounts

Returns the available Bank Accounts in Stripe and supports creating, updating, and deleting them.

Table-Specific Information

SELECT

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


Column	Supported Operators
Id	=
CustomerId	=
AccountId	=

To query the BankAccounts table, CustomerId is required:

SELECT * FROM BankAccounts WHERE CustomerId = 'cus_12345678'

INSERT

To create a new bank account, specify Country, Currency, and AccountNumber. CustomerId and Object are required:

INSERT INTO BankAccounts (AccountNumber, Country, Currency, Object, AccountHolderName, AccountHolderType, MetadataAggregate, CustomerId, RoutingNumber) VALUES (000999999991, 'US', 'usd', 'bank_account', 'Test1', 'company', '[{\"Check\":\"123\",\"QWERTY\":\"456\"}]', 'cus_PEDFTqrddhgBaF', 110000000)

UPDATE

To update a bank account, specify an Id and a CustomerId:

UPDATE BankAccounts SET AccountHolderName = 'My Name', AccountHolderType = 'individual' WHERE Id = 'ba_12345678' AND CustomerId = 'cus_12345678'

DELETE

To delete a bank account, specify an Id and a CustomerId:

DELETE FROM BankAccounts WHERE Id = 'ba_12345678' AND CustomerId = 'cus_12345678'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The Id for the bank account.
CustomerId [KEY]	String	False		The customer Id this account belongs to.
Account	String	True		The account Id.
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.
AccountNumber	String	False		The type of entity that holds the account.
BankName	String	True		The name of the bank associated with the routing number.
Country	String	False		Two-letter ISO code representing the country the bank account is located in.
Currency	String	False		Three-letter ISO currency code representing the currency paid out to the bank account.
DefaultForCurrency	Boolean	True		Indicates whether this bank account is the default external account for its currency.
Fingerprint	String	True		Uniquely identifies this particular bank account. You can use this attribute to check whether two bank accounts are the same.
Last4	String	True		The last 4 digits of the bank account.
RoutingNumber	String	False		The routing transit number for the bank account.
Status	String	True		The status of the account.
AccountType	String	True		The bank account type. This can only be checking or savings in most countries. In Japan, this can only be futsu or toza.
MetadataAggregate	String	False		A set of key-value pairs that you can attach to the bank account.
Object	String	False		The string representing the object's type. Objects of the same type share the same value. The allowed values are bank_account.
AvailablePayoutMethods	String	True		A set of available payout methods for this bank account. Only values from this set should be passed as the method when creating a payout.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.


Name	Type	Description
Source	String	The token Id.
AccountId	String	The Id of the connected account to get bank accounts for.

SSIS Components for Stripe