Templates
Retrieves available email templates in HubSpot, facilitating standardized communication design.
Table Specific Information
Templates represent any templates you have saved in the HubSpot content optimization system. The templates allow you to easily create new pages with the same look of other pages on your site.
SELECT
When selecting templates, they can only be filtered by the Id, CategoryId, DeletedAt, Folder, IsAvailableForNewContent, Label, and Path. DeletedAt can be used with the > and < comparisons but cannot form a range. For example:
SELECT * FROM Templates WHERE DeletedAt >= '1/1/2014' SELECT * FROM Templates WHERE Id = '123456789'
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | Unique identifier assigned to the template. | |
| CategoryId | Long | Numeric code representing the type of content this template supports: 1 for landing pages, 2 for emails, and 3 for site pages. | |
| CDNMinifiedUrl | String | URL of the minified and optimized version of JavaScript or CSS content uploaded to HubSpot's Content Delivery Network (CDN). | |
| CDNUrl | String | URL of the rendered version of non-HTML templates uploaded to HubSpot's Content Delivery Network (CDN). | |
| DeletedAt | Datetime | Timestamp indicating when the template was deleted, if applicable. | |
| Folder | String | Folder location within HubSpot where the template is stored. | |
| GeneratedFromLayoutId | String | ID of the layout file from which this template was generated. | |
| IsAvailableForNewContent | Boolean | Boolean indicating whether this template is available in the content creation workflow. | |
| IsFromLayout | Boolean | Boolean specifying if the template was auto-generated by publishing a layout. | |
| IsReadOnly | Boolean | Boolean indicating whether the template is read-only and cannot be edited. | |
| Label | String | The display label of the template as shown within the template builder interface. | |
| Path | String | The file path to reference the template in HubL include statements. | |
| Source | String | Raw markup source code of the template, including HTML and HubL tags. | |
| ThumbnailPath | String | URL path to the thumbnail image representing the template visually. | |
| UpdatedAt | Datetime | Timestamp showing the last modification date and time of the template. | |
| ExtraUrlParameters | String | Optional input-only property for specifying additional query parameters. Format parameters as name=value pairs separated by commas (for example: 'param1=value1, param2=value2, param3=value3'). |