Pages
Retrieves all pages created within HubSpot, including website, landing, and blog pages.
Table Specific Information
Pages represent any pages you have published with the HubSpot content optimization system.
SELECT
When selecting pages, they can only be filtered by the Id, ArchivedAt, ArchivedInDashboard, CampaignId, CreatedAt, IsDraft, Name, PublishDate, Slug, Subcategory, and UpdatedAt. CreatedAt, UpdatedAt and PublishDate may be used with > and < to form a range. ArchivedAt can be used with the > and < comparisons but cannot form a range. For example:
SELECT * FROM Pages WHERE CreatedAt >= '1/1/2014' AND CreatedAt <= '10/1/2014' SELECT * FROM Pages WHERE UpdatedAt >= '1/1/2014' AND UpdatedAt <= '10/1/2014' SELECT * FROM Pages WHERE PublishDate >= '1/1/2014' AND PublishDate <= '10/1/2014' SELECT * FROM Pages WHERE ArchivedAt >= '1/1/2014'
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | Unique identifier for the page. | |
| ArchivedInDashboard | Boolean | Indicates whether the page is hidden from the dashboard view while still remaining live. | |
| CampaignId | String | The unique GUID of the marketing campaign associated with this page. | |
| CampaignName | String |
EmailCampaigns.Name | The name of the marketing campaign linked to this page. |
| CreatedAt | Datetime | Timestamp marking when the page was originally created. | |
| CurrentLiveDomain | String | The domain name where the page is currently hosted. | |
| ArchivedAt | Datetime | Timestamp indicating when the page was archived or deleted. | |
| FooterHTML | String | Custom HTML code (such as embed codes or scripts) to be included before the closing body tag of the page. | |
| HeaderHTML | String | Custom HTML code (such as embed codes, scripts, or metadata) inserted in the head tag of the page. | |
| IsDraft | Boolean | Boolean indicating whether the page is still in draft status and not publicly visible. | |
| MetaDescription | String | Text for the meta description tag, used for search engine snippets and SEO. | |
| MetaKeywords | String | Comma-separated keywords added to the page's meta tag for SEO purposes. | |
| Name | String | The internal name of the page, used within HubSpot for reference. | |
| Password | String | Password required to view the page, if set. Makes the page password protected. | |
| PublishDate | Datetime | Scheduled publish date and time of the page, represented in milliseconds since the Unix epoch. | |
| Slug | String | URL path component where the page will be accessible. Modifying this alters the page's URL. | |
| StyleOverrideId | String | ID of the custom style or theme applied to override the default site style for this page. | |
| Subcategory | String | Optional subcategory used for classifying the page. This field may be empty. | |
| UpdatedAt | Datetime | Timestamp of the last update made to the page. | |
| Url | String | Full URL including domain and scheme where the page is accessible. Returns a 404 error code if unpublished. | |
| ExtraUrlParameters | String | Optional input-only property for specifying additional query parameters when selecting data. Format as name=value pairs separated by commas, for example: 'param1=value1, param2=value2, param3=value3'. |