Power BI Connector for Zoho Books

Build 20.0.7654


Retrieves list of all contact persons. Also, get the contact person details.

Table Specific Information


The {i 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 {i.

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


Name Type References SupportedOperators Description
CustomerContactId [KEY] String ID of a contact person.
ContactId String


Id of a contact.
ContactName String Display Name of the contact. Max-length [200].
CreatedTime Datetime Time at which the contact person was created.
CurrencyCode String Currency code used for this contact person.
Department String Department on which a person belongs. .
Designation String Designation of a person.
Email String Email ID of contact person.
Fax String Fax ID of contact person.
FirstName String First name of the contact person.
IsPrimaryContact Boolean Check if it is a primary contact.
LastName String Last name of contact person.
Mobile String Mobile number of a contact person.
Phone String Phone number of a contact person.
Salutation String Salutation of a contact person.
Skype String Skype ID of contact person.

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