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 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 | Represents the unique ID of the email template. |
| Active | Boolean | Active. |
| 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. |
| LastVersionStatisticsBounced | Integer | The statistics such as the number of emails that were bounced, that used this template. |
| LastVersionStatisticsClicked | Integer | The statistics such as the number of emails that were clicked, that used this template. |
| LastVersionStatisticsDelivered | Integer | The statistics such as the number of emails that were delivered, that used this template. |
| LastVersionStatisticsOpened | Integer | The statistics such as the number of emails that were opened, that used this template. |
| LastVersionStatisticsSent | Integer | The statistics such as the number of emails that were sent, that used this template. |
| LastVersionStatisticsTracked | Integer | The statistics such as the number of emails that were tracked, that used this template. |
| 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. |