ContactContactPersons

Get contact person related to contact

Table Specific Information

Select

The add-in will use the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the add-in.

ContactId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM ContactContactPersons WHERE ContactId = '3350895000000089001'

Columns


Name	Type	References	Description
ContactId	Long	Contacts.Id	Unique ID generated for contacts by the server.
ContactPersonId	Long		Unique ID generated for contacts person by the server.
Department	String		Department of the contact person.
Designation	String		Designation of the contact person.
Email	String		Search contacts by email id of the contact person.
FirstName	String		First name of the contact.
IsPortalInvitation	Boolean		Checks whether the contact person is invited to portal.
IsAddedInPortal	Boolean		Checks whether the contact person is added in portal.
IsPrimaryContact	Boolean		To mark contact person as primary for contact.
LastName	String		Last name of the contact.
Mobile	String		Search contacts by mobile number of the contact person.
Phone	String		Search contacts by phone number of the contact person.
Salutation	String		Salutation for the contact.
CanInvite	Boolean		Whether the contact person can be invited.
CommunicationPreferenceIsEmailEnabled	Boolean		Whether email communication is enabled.
ContactpersonCustomFields	String		Custom fields for the contact person.
Fax	String		Fax number.
IsPortalMfaEnabled	Boolean		Whether portal MFA is enabled.
PhotoUrl	String		URL of the contact person photo.
Skype	String		Skype ID.
ZcrmContactId	Long		Zoho CRM contact ID.
IsSmsEnabledForCp	Boolean		Whether SMS is enabled for the contact person.
MobileCodeFormatted	String		Formatted mobile code.
MobileCountryCode	String		Mobile country code.
PhotoDocumentName	String		Name of the photo document.
PhotoDocumentUrl	String		URL of the photo document.
PortalEnabledVia	String		Method by which portal was enabled.

Excel Add-In for Zoho Inventory

ContactContactPersons

Table Specific Information

Select

Columns