Excel Add-In for Zoho Inventory

Build 24.0.9060

ContactContactPersons

Get contact persons of the contacts.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060