EmailTemplates
Retrieves metadata and HTML content of email templates available for automation or manual sends.
Table-Specific Information
Note : This view is available for API Version 2.1 and above.
Select
The connector will use the Zoho CRM API to process WHERE clause conditions built with the following column and operator.
- Id supports the '=,IN' operator.
- ModuleApiName supports the '=,IN' operator.
For example, the following queries are processed server side:
SELECT * FROM EmailTemplates SELECT * FROM EmailTemplates where id = '721000000' SELECT * FROM EmailTemplates where ModuleApiName='Accounts'
Columns
| Name | Type | Description |
| Id [KEY] | String | The unique identifier of the email template. |
| Associated | Boolean | Indicates whether the email template is associated with any module. |
| Attachments | String | The attachments included in the email template. |
| Category | String | The type or classification of the email template.
The allowed values are custom_templates, system_templates, plugin_templates, marketplace_templates. |
| ConsentLinked | Boolean | Indicates whether a consent form is linked to the email template. |
| CreatedById | String | The unique identifier of the user who created the email template. |
| CreatedByName | String | The name of the user who created the email template. |
| CreatedTime | Datetime | The date and time when the email template was created. |
| EditorMode | String | The editor mode used to create the email template.
The allowed values are gallery, rich_text, plain_text. |
| Favorite | Boolean | Indicates whether the email template is marked as a favorite. |
| FolderId | String | The unique identifier of the folder containing the email template. |
| FolderName | String | The name of the folder containing the email template. |
| LastUsageTime | Datetime | The date and time when the email template was last used. |
| Layout | String | The identifier of the layout associated with the email template. |
| ModifiedById | String | The unique identifier of the user who last modified the email template. |
| ModifiedByName | String | The name of the user who last modified the email template. |
| ModifiedTime | Datetime | The date and time when the email template was last modified. |
| ModuleApiName | String | The API name of the module associated with the email template. |
| ModuleId | String | The unique identifier of the module associated with the email template. |
| Name | String | The name of the email template. |
| Subject | String | The subject line defined for the email template. |