BlogPosts

Retrieve the available 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	References	Description
Id [KEY]	Long		The id of the blog post.
AuthorUserId	Long		The HubSpot user id of the blog author.
AuthorName	String		The HubSpot username of the blog author.
BlogAuthorId	Long	BlogAuthors.Id	The integer id of the blog author, look up via the blog authors end.
CampaignId	String	EmailCampaigns.Id	The guid of the marketing campaign this post is associated with.
ContentGroupId	Long		The id of the blog that this post belongs to. Get the id by looking at the blog API.
TopicIds	String		The individual topics the post is associated with.
CreatedAt	Datetime		When the post was first created.
ArchivedAt	Datetime		When the post was deleted.
ArchivedInDashboard	Boolean		If True, the post will not show up in your dashboard, although the post will still be live.
Name	String		The internal name of the blog post.
Slug	String		The path of the URL on which the post will live.
UpdatedAt	Datetime		When the post was last updated.
PublishedAt	Datetime		When the post was published.
PostSummary	String		The summary of the blog post that will appear on the main listing page.
PostBody	String		The HTML of the main post body.
Url	String		The full URL with domain and scheme to the blog post. Will return a 404 if the post 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'.

SSIS Components for HubSpot

BlogPosts

Table Specific Information

SELECT

Columns