Templates
Retrieve the available templates in HubSpot.
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 | The id of the template. | |
| CategoryId | Long | The category of content this template can be used for. 1 for landing page, 2 for email, 3 for site page. | |
| CDNMinifiedUrl | String | For javascript and css, this is the URL of the version of the content that has been rendered, minified, and uploaded to our Content Delivery Network. | |
| CDNUrl | String | For non-html templates, the URL to the version of the template that has been rendered and uploaded to the HubSpot CDN. | |
| DeletedAt | Datetime | When the template was deleted. | |
| Folder | String | The folder this template lives in. | |
| GeneratedFromLayoutId | String | The id of the layout that generated this template. | |
| IsAvailableForNewContent | Boolean | True if this template will show up in the content creation screen. | |
| IsFromLayout | Boolean | True if template was generated by publishing a layout. | |
| IsReadOnly | Boolean | True if the template can only be read. | |
| Label | String | The label of the template as it shows up in the template builder. | |
| Path | String | The path of the template, as should be used for HubL include statements. | |
| Source | String | The markup of the template. | |
| ThumbnailPath | String | The thumbnail image of the template. | |
| UpdatedAt | Datetime | When the template was last updated. | |
| ExtraUrlParameters | String | An input only property for specifying additional parameters when selecting data from HubSpot. Specify the parameters as name=value pairs in a comma separated list. For instance, 'param1=value1,param2=value2,param3=value3'. |