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 add-in 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. |