MuleSoft Connector for Stripe

Build 21.0.7930

BankAccounts

Create, update, delete, and query the available Bank Accounts in Stripe.

Table Specific Information

Select

Server-Side Query Support

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

  • Id, CustomerId support the following operators: =

To query BankAccounts table, CustomerId is required:

SELECT * FROM BankAccounts WHERE CustomerId='cus_12345678'

In addition to CustomerId, provider supports all columns to be used as criteria in the Where clause of Select statement, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retreive a Bank Account by specifying its Id:

SELECT * FROM BankAccounts WHERE Id='ba_12345678' AND CustomerId='cus_12345678'

Insert

To create a new Bank Account, specify Country, Currency, and AccountNumber. CustomerId is required.

INSERT INTO BankAccounts (CustomerId, Country, Currency, AccountHolderName, AccountHolderType, AccountNumber, RoutingNumber) VALUES ('cus_1kghj5755loee', 'US' , 'usd', 'Sab nu' , 'individual', '000123456789','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 True

The customer id this account belongs to.

Account String False

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 False

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 False

This indicates whether or not 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

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.

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
Token String

The token ID

AccountId String

The Id of the connected account to get back accounts for

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930