InvoicesContactPersons
List Contact Persons of the invoices.
Table Specific Information
Select
The connector 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 connector.
- 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 | Unique ID of the contact person. | |
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. |