InvoicesContactPersons

List Contact Persons of the invoices.

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.

InvoiceId supports the '=' comparison.
ContactPersonId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM InvoicesContactPersons WHERE InvoiceId = '3350895000000089001'

SELECT * FROM InvoicesContactPersons WHERE ContactPersonId = '3350895000000089001'

Columns


Name	Type	References	Description
InvoiceId	Long	Invoices.Id	Invoice Id
ContactPersonId [KEY]	Long	ContactPersons.Id	Unique ID of the contact person.
Email	String		Contact email id.
FirstName	String		First name of the contact.
IsPrimaryContact	String		To mark contact person as primary for contact.
LastName	String		Last name of the contact.
Mobile	String		Mobile number of the contact person.
Phone	String		Phone number of the contact.
Salutation	String		Salutation to the contact.

Excel Add-In for Zoho Inventory

InvoicesContactPersons

Table Specific Information

Select

Columns