JDBC Driver for Zoho Books

Build 22.0.8479


Create, Read, Update, Delete contact persons. Also, get the contact person details.

Table Specific Information


The 本製品 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 本製品.

  • ContactId supports the '=' comparison.
  • CustomerContactId supports the '=' comparison.
For example:
    SELECT * FROM CustomerContacts WHERE ContactId = '1864553000000072009' AND CustomerContactId = '1896253000000071011'


Insert can be executed by specifying FirstName,CONTACTID 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 CustomerContacts (FirstName,CONTACTID) VALUES ('customercontactspersons','3285934000000085043') 


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

UPDATE CUSTOMERCONTACTS SET CONTACTID='3285934000000085043', LASTNAME='TEST' where customercontactid='3285934000000266024'


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

DELETE FROM CUSTOMERCONTACTS WHERE CustomerContactId = '3285934000000266024'


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

ID of a contact person.

ContactId String False


Id of a contact.

ContactName String True

Display Name of the contact. Max-length [200].

CreatedTime Datetime True

Time at which the contact person was created.

CurrencyCode String True

Currency code used for this contact person.

Department String False

Department on which a person belongs. .

Designation String False

Designation of a person.

Email String False

Email ID of contact person.

EnablePortal Boolean False

Option to enable the portal access. allowed values true,false

Fax String True

Fax ID of contact person.

FirstName String False

First name of the contact person.

IsPrimaryContact Boolean False

Check if it is a primary contact.

LastName String False

Last name of contact person.

Mobile String False

Mobile number of a contact person.

Phone String False

Phone number of a contact person.

Salutation String False

Salutation of a contact person.

Skype String False

Skype ID of contact person.

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