CustomerContacts

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

Table Specific Information

Select

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'

Columns


Name	Type	References	SupportedOperators	Description
CustomerContactId [KEY]	String			ID of a contact person.
ContactId	String	Contacts.ContactId		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.

ADO.NET Provider for Zoho Books

CustomerContacts

Table Specific Information

Select

Columns