EmailTemplates
Retrieves metadata and HTML content for email templates available for automation or manual sending.
Table-Specific Information
Note : This view is available for API Version 2.1 and above.
Select
The server 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. |
| Active | Boolean | Indicates whether the email template is active. |
| Associated | Boolean | Indicates whether the template is associated with a module. |
| Attachments | String | The attachments included in the email template. |
| Category | String | The type of email template, such as standard or automated.
The allowed values are custom_templates, system_templates, plugin_templates, marketplace_templates. |
| ConsentLinked | Boolean | Indicates whether a consent form is linked to the 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 editing 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 where the template is stored. |
| FolderName | String | The name of the folder where the template is stored. |
| LastUsageTime | Datetime | The date and time when the template was last used. |
| LastVersionStatisticsBounced | Integer | The number of emails that bounced when this template was last used. |
| LastVersionStatisticsClicked | Integer | The number of emails that were clicked when this template was last used. |
| LastVersionStatisticsDelivered | Integer | The number of emails that were successfully delivered using this template. |
| LastVersionStatisticsOpened | Integer | The number of emails that were opened using this template. |
| LastVersionStatisticsSent | Integer | The number of emails that were sent using this template. |
| LastVersionStatisticsTracked | Integer | The number of emails that were tracked using this template. |
| Layout | String | The layout identifier associated with the 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 template. |
| ModuleId | String | The unique identifier of the module associated with the template. |
| Name | String | The name of the email template. |
| Subject | String | The subject line of the email template. |