ODBC Driver for HubSpot

Build 23.0.8839


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.


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'


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'.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839