MuleSoft Connector for Zoho Books

Build 20.0.7654

BankAccounts

Retrieves list of all bank and credit card accounts for your organization.

Table Specific Information

Select

The connector will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.

  • AccountId supports the '=' comparison.
  • AccountCodeAccountName supports the '=' comparison.
  • AccountType supports the '=' comparison.
  • Status supports the '=' comparison.
For example:
    SELECT * FROM BankAccounts WHERE Status = 'All'

    SELECT * FROM BankAccounts WHERE AccountId = '1894343000000085314'

Columns

Name Type References SupportedOperators Description
AccountId [KEY] String Id of the Bank Account.
AccountCode String Code of the Account.
AccountName String Name of the account.
AccountType String Type of the account.
Balance Decimal The unpaid amount.
BankBalance Decimal Total balance in Bank.
BankName String Name of the Bank.
BcyBalance Decimal Balance of Base Currency.
CanShowInZe Boolean Check if it can show in Zero Emission.
CanShowPaypalDirectIntegBanner Boolean Check if it can show direct integ banner.
CurrencyCode String Currency code of the customer's currency.
CurrencyId String

Currencies.CurrencyId

Currency ID of the customer's currency.
CurrencySymbol String Currency symbol of the customer's currency.
Description String Description of the Account.
IsActive Boolean Check if bank account is active.
IsDirectPaypal Boolean Check if bank account is direct by paypal.
PricePrecision Integer The precision for the price.
TotalUnprintedChecks Integer Total number of unprinted checks.
UncategorizedTransactions Integer Number of uncategorized transactions.

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
Status String Filter bills by any status.

The allowed values are All, PartiallyPaid, Paid, Overdue, Void, Open.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654