InventoryTemplates
To fetch the details of inventory templates.
View-Specific Information
Select
The driver uses the Zoho CRM API to process WHERE clause conditions built with the following columns and operators.
- Id supports the '=' operator.
- ModuleApiName supports the '=' operator.
- Type supports the '=' operator.
For example, the following queries are processed server side:
SELECT * from InventoryTemplates WHERE Id = '1170218000000567996'; SELECT * from InventoryTemplates WHERE ModuleApiName = 'Purchase_Orders'; SELECT * from InventoryTemplates WHERE Type = 'created_by_me';
Columns
| Name | Type | Description |
| Id [KEY] | String | Represents the unique ID of the inventory template. |
| Name | String | Represents the name of the template. |
| Category | String | Represents the category of the template. The possible values are custom_templates: the templates created by a user, system_templates: the templates present in the system by default, plugin_templates: the templates that are created and installed from the Zoho CRM extension, marketplace_templates: the templates that are created and installed from the published plugins.
The allowed values are custom_templates, system_templates, plugin_templates, marketplace_templates. |
| CreatedById | String | Represents the ID of the user who created the inventory template. |
| CreatedByName | String | Represents the name of the user who created the inventory template. |
| CreatedAt | Datetime | Represents the date and time at which the inventory template was created. |
| EditorMode | String | Represents the mode in which the inventory template is created. The possible values are gallery: the template is chosen from the template gallery and is customized, rich_text: a pre-designed custom template, plain_text: the template is built from scratch.
The allowed values are gallery, rich_text, plain_text. |
| Favorite | Boolean | Represents if the inventory 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 inventory template was last used. |
| ModifiedById | String | Represents the ID of the user who last modified the inventory template. |
| ModifiedByName | String | Represents the name of the user who last modified the inventory template. |
| ModifiedAt | Datetime | Represents the date and time at which the inventory template was last modified. |
| ModuleApiName | String | Represents the API name of the module with which the inventory template is associated. |
| ModuleId | String | Represents the unique ID of the module with which the inventory template is associated. |
| Content | String | Contains the HTML of the email template and is rendered in the response only when you fetch a specific email template. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Type | String | To filter the inventory templates based on their type. The possible values are favorite: templates marked as your favorite, created_by_me: templates that you created, shared_with_me: templates that other users shared with you, and draft: templates in your draft.
The allowed values are favorite, created_by_me, shared_with_me, draft. |