JDBC Driver for Zoho Inventory

Build 22.0.8462

InvoicesContactPersons

List Contact Persons of the invoices.

Table Specific Information

Select

The driver 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 driver.

  • 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462