CData BizTalk Adapter for HubSpot 2019 - Online Help
Questions / Feedback?

Pages

CData BizTalk Adapter for HubSpot 2019 - Build 19.0.7424

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 ReadOnly References Description
Id [KEY] Long True

The id of the page.

IsArchived Boolean True

If True, the page will not show up in your dashboard, although the page will still be live.

CampaignId String False

EmailCampaigns.Id

The guid of the marketing campaign this page is associated with.

CampaignName String False

EmailCampaigns.Name

The name of the marketing campaign this page is associated with.

CreatedAt Datetime True

When the page was created.

CurrentLiveDomain String True

The domain this page is currently located on.

DeletedAt Datetime True

When the page was deleted.

FooterHTML String False

Custom HTML for embed codes, javascript that should be placed before the body tag of the page

HeaderHTML String False

Custom HTML for embed codes, javascript, etc. that goes in the head tag of the page

IsDraft Boolean False

True if the post is still a draft, invisible to the public. Gets changed when the /publish-action API endpoint is called.

MetaDescription String False

A description that goes in meta tag on the page

MetaKeywords String False

Keywords for the meta tag.

Name String False

The internal name of the page.

Password String False

Set this to create a password protected page. Entering the password will be required to view the page.

PublishDate Datetime False

The date the page is to be published at in milliseconds since the unix epoch.

Slug String False

The path of the URL on which the page will live. Changing this will change the URL.

StyleOverrideId String True

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 False

This is set to empty or to

UpdatedAt Datetime True

When the page was last updated.

Url String True

The full URL with domain and scheme to the page. Will return a 404 if the page is not yet published.

ExtraUrlParameters String True

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) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7424.0