JDBC Driver for HubSpot

Build 22.0.8462

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, IsArchived, CampaignId, CreatedAt, DeletedAt, IsDraft, Name, PublishDate, Slug, Subcategory, and UpdatedAt. CreatedAt, UpdatedAt and PublishDate may be used with > and < to form a range. DeletedAt 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 DeletedAt >= '1/1/2014'

Columns

Name Type References Description
Id [KEY] Long The id of the page.
IsArchived Boolean If True, the page will not show up in your dashboard, although the page will still be live.
CampaignId String

EmailCampaigns.Id

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462