EmailTemplates
To fetch the email templates in a module.
Table-Specific Information
Note : This view is available for API Version 2.1 and above.
Select
The driver 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 | Represents the unique ID of the email template. |
| Associated | Boolean | Represents whether the template is associated or not. |
| Attachments | String | Represents the attachments added in the template. |
| Category | String | Represents the type of the template.
The allowed values are custom_templates, system_templates, plugin_templates, marketplace_templates. |
| ConsentLinked | Boolean | Represents whether the consent form is linked with the template. |
| CreatedById | String | Represents the ID of the user who created the email template. |
| CreatedByName | String | Represents the name of the user who created the email template. |
| CreatedTime | Datetime | Represents the date and time at which the email template was created. |
| EditorMode | String | Represents the mode in which the email template is created.
The allowed values are gallery, rich_text, plain_text. |
| Favorite | Boolean | Represents if the email template is marked as favorite. |
| FolderId | String | Represents the unique ID of the template folder. |
| FolderName | String | Represents the name of the template folder. |
| LastUsageTime | Datetime | Represents the date and time at which the email template was last used. |
| Layout | String | Represents the layout Id the template is associated with. |
| ModifiedById | String | Represents the ID of the user who last modified the email template. |
| ModifiedByName | String | Represents the name of the user who last modified the email template. |
| ModifiedTime | Datetime | Represents the date and time at which the email template was last modified. |
| ModuleApiName | String | Represents the module api name with which the template is associated with. |
| ModuleId | String | Represents the module id with which the template is associated with. |
| Name | String | Represents the name of the email template. |
| Subject | String | Represents the subject of the email template. |