Retrieves the content of the mail sent to a contact.

Table Specific Information

Select

The connector uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:

• ContactId supports '=,IN' comparisons.
• StartDate supports '=' comparisons.
• EndDate supports '=' comparisons.

The rest of the filter is executed client-side in the connector.

For example:

    SELECT * FROM GetContactStatementEmailContent WHERE contactid = '3255827000000093001'

    SELECT * FROM GetContactStatementEmailContent WHERE contactid = '3255827000000093001' AND startdate = '22-01-2023' 

    SELECT * FROM GetContactStatementEmailContent WHERE contactid IN ('3255827000000093001', '3255827000000102354')

Columns

Name	Type	References	SupportedOperators	Description
Body	String			The Body of an email has to be sent. Max-length [5000]
StartDate	Date		=	The Date when or after the contact was created
EndDate	Date		=	The Date after the contact was created
ContactId	String	Contacts.ContactId	=	The Contact Id
FileName	String			The File Name
FromEmails	String			The From Emails
Subject	String			The Subject of an email has to be sent. Max-length [1000]
ToContacts	String			To Contacts
ContactName	String			Name of the contact.
EmailTemplates	String			List of email templates.
FileNameWithoutExtension	String			File name without the extension.
FromEmail	String			Email address of the sender.
BccMails	String			List of BCC email addresses.
BccMailsStr	String			Comma-separated string of BCC emails.
CcMailsList	String			List of CC email addresses.
CcMailsStr	String			Comma-separated string of CC emails.
FromAddress	String			Physical address of the sender.
ToMailsStr	String			Comma-separated string of recipient emails.