SSIS Components for Zoho Inventory

Build 24.0.9060

InvoicesGetMailContentToContacts

List to contacts of Mail Content for Invoices.

Table Specific Information

Select

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

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

For example, the following queries are processed server side:

SELECT * FROM InvoicesGetMailContentToContacts WHERE ContactPersonId = '3350895000000089001'

SELECT * FROM InvoicesGetMailContentToContacts WHERE InvoiceId = '1937623621'

Columns

Name Type References Description
InvoiceId Long

Invoices.Id

Invoice Id.
FirstName String First name.
LastName String Last name.
Selected String Selected.
Phone String Phone.
Email String Email.
Salutation String Salutation.
ContactPersonId [KEY] Long

ContactPersons.Id

Contact Person Id.
Mobile String Mobile.

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