GetContactStatementEmailContent
Get the content of the mail sent to a contact.
Table Specific Information
Select
The component uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- ContactId supports the '=,IN' comparison.
- StartDate supports the '=' comparison.
- EndDate supports the '=' comparison.
The rest of the filter is executed client-side in the component.
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 | Body of an email has to be sent. Max-length [5000] | ||
| StartDate | Date | = | Date when or after the contact was created | |
| EndDate | Date | = | Date after the contact was created | |
| ContactId | String |
Contacts.ContactId | = | Contact Id |
| FileName | String | File Name | ||
| FromEmails | String | From Emails | ||
| Subject | String | Subject of an email has to be sent. Max-length [1000] | ||
| ToContacts | String | To Contacts |