BlogPosts

Retrieves all blog posts created in HubSpot, allowing management and analysis of blog performance.

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		Unique identifier assigned to the blog post.
AuthorUserId	Long		HubSpot user ID of the author who created the blog post.
AuthorName	String		Username of the blog author in HubSpot.
BlogAuthorId	Long	BlogAuthors.Id	Unique identifier of the blog author record. Cross-reference with the blog authors table.
CampaignId	String	EmailCampaigns.Id	GUID of the marketing campaign associated with the blog post, if applicable.
ContentGroupId	Long		Unique identifier of the blog to which this post belongs. Retrieved via the blog API.
TopicIds	String		Comma-separated list of topic IDs associated with the blog post.
CreatedAt	Datetime		Timestamp indicating when the blog post was originally created.
ArchivedAt	Datetime		Timestamp marking when the blog post was archived or deleted, if applicable.
ArchivedInDashboard	Boolean		Indicates whether the post is hidden from the dashboard while still being live on the site.
Name	String		Internal name assigned to the blog post for organizational purposes.
Slug	String		URL path where the blog post will be accessible.
UpdatedAt	Datetime		Timestamp indicating the last update made to the blog post.
PublishedAt	Datetime		Timestamp indicating when the blog post was published and made live.
PostSummary	String		Short summary of the blog post, displayed on the main blog listing page.
PostBody	String		HTML content of the main body of the blog post.
Url	String		Full URL including domain and protocol for accessing the blog post. Returns a 404 error code if unpublished.
ExtraUrlParameters	String		Optional input-only parameter to specify additional query parameters when retrieving blog post data. The format is: 'param1=value1, param2=value2, param3=value3'.

ODBC Driver for HubSpot

BlogPosts

Table Specific Information

SELECT

Columns