Pages
Retrieve the available pages in HubSpot.
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 | The id of the page. | |
| ArchivedInDashboard | Boolean | If True, the page will not show up in your dashboard, although the page will still be live. | |
| CampaignId | String | The guid of the marketing campaign this page is associated with. | |
| CampaignName | String |
EmailCampaigns.Name | The name of the marketing campaign this page is associated with. |
| CreatedAt | Datetime | When the page was created. | |
| CurrentLiveDomain | String | The domain this page is currently located on. | |
| ArchivedAt | Datetime | When the page was deleted | |
| FooterHTML | String | Custom HTML for embed codes, javascript that should be placed before the body tag of the page | |
| HeaderHTML | String | Custom HTML for embed codes, javascript, etc. that goes in the head tag of the page | |
| IsDraft | Boolean | True if the post is still a draft, invisible to the public. Gets changed when the /publish-action API endpoint is called. | |
| MetaDescription | String | A description that goes in meta tag on the page | |
| MetaKeywords | String | Keywords for the meta tag. | |
| Name | String | The internal name of the page. | |
| Password | String | Set this to create a password protected page. Entering the password will be required to view the page. | |
| PublishDate | Datetime | The date the page is to be published at in milliseconds since the unix epoch. | |
| Slug | String | The path of the URL on which the page will live. Changing this will change the URL. | |
| StyleOverrideId | String | The ID of the style to use for this page, set this to use a different style than the default style for the site. | |
| Subcategory | String | This is set to empty or to | |
| UpdatedAt | Datetime | When the page was last updated. | |
| Url | String | The full URL with domain and scheme to the page. Will return a 404 if the page is not yet published. | |
| 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'. |