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 that 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			From Emails.
Subject	String			The Subject of an email that has to be sent. Max-length [1000].
ToContacts	String			To Contacts.