JDBC Driver for Zoho Inventory

Build 22.0.8462

InvoiceGetMailContent

Get mail contents of 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.

For example, the following queries are processed server side:

SELECT * FROM InvoiceGetMailContent WHERE InvoiceId = '3350895000000089001'

Columns

Name Type References Description
InvoiceId Long

Invoices.Id

Invoice Id.
AttachPdf Boolean Attach pdf
AttachmentName String Attachment name
BccMails String Bcc mails
BccMailsStr String Bcc mails str
Body String Body
CcMailsList String Cc mails list
CcMailsStr String Cc mails str
CustomerId Long Customer id
CustomerName String Customer name
DeprecatedPlaceholdersUsed String Deprecated placeholders used
Documents String Documents
EmailtemplateDocuments String Emailtemplate documents
Emailtemplates String Email templates
EntityId String Entity id
ErrorList String Error list
FileName String File name
FileNameWithoutExtension String File name without extension
FromAddress String From address
FromEmail String From email
FromEmails String From emails
GatewaysAssociated Boolean Gateways associated
GatewaysConfigured Boolean Gateways configured
Subject String Subject
ToContacts String To contacts
ToMailsStr String To mails str

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