Power BI Connector for HubSpot

Build 26.0.9770

BlogPosts

Blog posts in HubSpot.

Table-Specific Information

Blog posts represent the individual posts in your HubSpot blog.

SELECT

When selecting blog posts, they can only be filtered by the Id, BlogAuthorId, ArchivedInDashboard, CampaignId, ContentGroupId, CreatedAt, ArchivedAt, Name, Slug, and UpdatedAt columns. CreatedAt, ArchivedAt, and UpdatedAt can be used with > and < where a range can be formed with CreatedAt and UpdatedAt. In addition, Name can be used with the LIKE comparison. All others must be used with an exact comparison. For example: 
SELECT * FROM BlogPosts WHERE CreatedAt >= '1/1/2014' AND CreatedAt <= '10/31/2014'
SELECT * FROM BlogPosts WHERE UpdatedAt >= '1/1/2014' AND UpdatedAt <= '10/31/2014'
SELECT * FROM BlogPosts WHERE ArchivedAt >= '1/1/2014'
SELECT * FROM BlogPosts WHERE Name LIKE 'My Post'

Columns

Name Type ReadOnly References Filterable Description
Id [KEY] String True True

The unique ID of the blog post.

Name String False True

The internal name of the post.

Slug String False True

The URL slug of the blog post. This field is appended to the domain to construct the url of this post.

ContentGroupId String False True

The ID of the post's parent blog.

BlogAuthorId String False True

The ID of the blog author associated with this post.

AuthorName String True

The name of the user who last published the blog post.

HTMLTitle String False

The HTML title of the post.

MetaDescription String False

A description that goes in meta tag on the page.

PostBody String False

The HTML of the main post body.

PostSummary String False

The summary of the blog post that will appear on the main listing page.

RSSBody String False

The contents of the RSS body for this blog post.

RSSSummary String False

The contents of the RSS summary for this blog post.

State String False True

An enumeration describing the current publish state of the post.

CurrentState String True

A generated ENUM describing the current state of this blog post.

CurrentlyPublished Boolean True

Whether the post is published (true or false).

PublishDate Datetime False

The date the blog post is to be published at.

PublishImmediately Boolean False

Set this to true if you want to be published immediately when the schedule publish endpoint is called.

Domain String False

The domain that the post lives on. If null, the post will default to the domain of the parent blog.

Url String True

A generated field representing the URL of this blog post.

Language String False

The explicitly defined ISO 639 language code of the post.

TranslatedFromId String False

ID of the primary blog post that this post was translated from.

FeaturedImage String False

The featured image of this blog post.

FeaturedImageAltText String False

Alt text of the featured image.

UseFeaturedImage Boolean False

Boolean to determine if this post should use a featured image.

Campaign String False True

The GUID of the marketing campaign the post is associated with.

CategoryId Int False

ID of the object type.

FolderId String False

Unique identifier of associated folder.

HeadHTML String False

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

FooterHTML String False

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

LinkRelCanonicalUrl String False

Optional override to set the URL to be used in the rel=canonical link tag on the page.

ContentTypeCategory String True

An ENUM describing the type of this object. Should always be BLOG_POST.

Password String False

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

EnableDomainStylesheets Boolean False

Boolean to determine whether or not the styles from the template should be applied.

EnableLayoutStylesheets Boolean False

Boolean to determine whether or not the styles from the template should be applied.

EnableGoogleAmpOutputOverride Boolean False

Boolean to allow overriding the AMP settings for the blog.

IncludeDefaultCustomCss Boolean False

Boolean to determine whether or not the primary CSS files should be applied.

PageExpiryEnabled Boolean False

Boolean describing if the page expiration feature is enabled for this blog post.

PageExpiryDate Long False

The date at which this blog post should expire and begin redirecting to another url or page.

PageExpiryRedirectId Long False

The ID of another page this blog post's url should redirect to once this blog post expires.

PageExpiryRedirectUrl String False

The URL this blog post's url should redirect to once it expires.

AbStatus String False

The status of the AB test associated with this blog post, if applicable.

AbTestId String False

The ID of the AB test associated with this page, if applicable.

MabExperimentId String False

Unique identifier of the MAB experiment.

ArchivedInDashboard Boolean False

If true, the post will not show up in your dashboard, although the post could still be live.

DynamicPageDataSourceId String False

The identifier for the data source used by the dynamic page.

DynamicPageDataSourceType Int False

The type of data source used by the dynamic page.

DynamicPageHubDbTableId String False

For dynamic HubDB pages, the ID of the HubDB table this post references.

PublicAccessRulesEnabled Boolean False

Boolean to determine whether or not to respect publicAccessRules.

Created Datetime True

The datetime when this blog post was created.

Updated Datetime True

The datetime when this blog post was updated.

CreatedById String True True

The ID of the user that created the post.

UpdatedById String True True

The ID of the user that updated the post.

TagIds String False

The IDs of the tags associated with this post.

AttachedStylesheets String False

List of stylesheets to attach to this blog post.

PublicAccessRules String False

Rules for require member registration to access private content.

LayoutSections String False

A structure detailing the layout sections of the blog post.

ThemeSettingsValues String False

A collection of settings specific to the theme applied to the blog post.

Translations String False

A map of translations for the blog post, each associated with a specific language variation.

WidgetContainers String False

A data structure containing the data for all the modules inside the containers for this post.

Widgets String False

A data structure containing the data for all the modules for this page.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770