JDBC Driver for Zoho Books

Build 22.0.8479


Retrieves list of all contacts.

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

  • ContactName supports the '=' comparison.
  • CompanyName supports the '=' comparison.
  • Status supports the '=' comparison.
  • FirstName supports the '=' comparison.
  • LastName supports the '=' comparison.
  • Email supports the '=' comparison.
  • Phone supports the '=' comparison.
  • Address supports the '=' comparison.
  • PlaceOfContact supports the '=' comparison.
For example:
    SELECT * FROM Contacts WHERE CONTAINS(LastName,'D')

    SELECT * FROM Contacts WHERE FirstName = 'John' AND Status = 'Active'

    SELECT * FROM Contacts LIMIT 5


Name Type References SupportedOperators Description
ContactId [KEY] String Id of a Contact.
ContactName String Name of a Contact.
CustomerName String Name of the customer.
VendorName String Name of the Vendor.
CompanyName String Name of a Company.
Website String Website of this contact.
LanguageCode String Language of a contact.
ContactType String Contact type of the contact.
Status String Status of the contact.

使用できる値は次のとおりです。All, Active, Inactive, Duplicate

CustomerSubType String Sub type of a customer.
Source String Source of the contact.
CurrencyId String


Currency ID of the customer's currency.
Facebook String Facebook profile account.
CurrencyCode String Currency code of the customer's currency.
OutstandingReceivableAmount Decimal Outstanding receivable amount of a contact.
OutstandingReceivableAmountBcy Decimal Base Currency of Outstanding receivable amount of a contact.
OutstandingPayableAmount Decimal Outstanding payable amount of a contact.
OutstandingPayableAmountBcy Decimal Base Currency of Outstanding payable amount of a contact.
UnusedCreditsPayableAmount Decimal Unused credits payable amount of a contact.
FirstName String First name of the contact person.
LastName String Last name of the contact person.
Email String Email address of the contact person.
Phone String Phone number of the contact person.
Mobile String Mobile number of the contact person.
PlaceOfContact String Code for the place of contact.
AchSupported Boolean Check if ACH is supported.
CreatedTime Datetime Time at which the contact was created.
GSTTreatment String Choose whether the contact is GST registered/unregistered/consumer/overseas.
HasAttachment Boolean Check if contacts has attachment.
LastModifiedTime Datetime The time of last modification of the contact.


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
Address String Address of a contact.

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