SSIS Components for Zoho Books

Build 22.0.8509


To list, add, update and delete bank and credit card accounts for your organization.

Table Specific Information


The component uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:

  • AccountId supports the '=' comparison.
  • AccountCodeAccountName supports the '=' comparison.
  • AccountType supports the '=' comparison.
  • Status supports the '=' comparison.

The rest of the filter is executed client-side in the component.

For example:

    SELECT * FROM BankAccounts WHERE Status = 'All'

    SELECT * FROM BankAccounts WHERE AccountId = '1894343000000085314'


Insert can be executed by specifying AccountName, AccountType columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO BankAccounts (AccountName, AccountType) VALUES ('testaccount1','bank') 


Update can be executed by specifying the AccountId in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE BankAccounts SET AccountName = 'Test Account', AccountType='bank' WHERE AccountId = '3285934000000264001'


Delete can be executed by specifying the AccountId in the WHERE Clause For example:

DELETE FROM BankAccounts WHERE AccountId = '3285934000000264001'


Name Type ReadOnly References SupportedOperators Description
AccountId [KEY] String True

Id of the Bank Account.

AccountCode String False

Code of the Account.

AccountName String False

Name of the account.

AccountType String False

Type of the account.

AccountNumber String False

Number associated with the Bank Account.

Balance Decimal True

The unpaid amount.

BankBalance Decimal True

Total balance in Bank.

BankName String False

Name of the Bank.

BcyBalance Decimal True

Balance of Base Currency.

CanShowInZe Boolean True

Check if it can show in Zero Emission.

CanShowPaypalDirectIntegBanner Boolean True

Check if it can show direct integ banner.

CurrencyCode String False

Currency code of the customer's currency.

CurrencyId String False


Currency ID of the customer's currency.

CurrencySymbol String True

Currency symbol of the customer's currency.

Description String False

Description of the Account.

IsActive Boolean True

Check if bank account is active.

IsDirectPaypal Boolean True

Check if bank account is direct by paypal.

IsPrimaryAccount Boolean False

Check if the Account is Primary Account in Zoho Books.

IsPaypalAccount Boolean False

Check if the Account is Paypal Account.

PricePrecision Integer True

The precision for the price.

PaypalType String False

The type of Payment for the Paypal Account. Allowed Values : standard and adaptive.

PaypalEmailAddress String False

Email Address of the Paypal account.

RoutingNumber String False

Routing Number of the Account.

TotalUnprintedChecks Integer True

Total number of unprinted checks.

UncategorizedTransactions Integer True

Number of uncategorized transactions.


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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8509