Templates
Retrieve paged transactional templates
View-Specific Information
Select
The following is an example to query the Templates view:
SELECT * FROM Templates
The connector will use the SendGrid API to process WHERE clause conditions built with the following column and operator.
- Generation supports the '='.
SELECT * FROM Templates WHERE Generation = 'dynamic'
Columns
| Name | Type | References | Description |
| ID [KEY] | String | The ID of the transactional template. | |
| Generation | String | Defines the generation of the template. By default, we will get data for both dynamic and legacy.
The allowed values are dynamic, legacy. | |
| Name | String | The name for the transactional template. | |
| UpdatedAt | String | The date and time that this transactional template version was updated. | |
| Versions | String | The different versions of this transactional template. |