ODBC Driver for HubSpot

Build 23.0.8839


Retrieve the available blog posts in HubSpot.

Table Specific Information

Blog posts represent the individual posts in your HubSpot blog.


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'


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


The integer id of the blog author, look up via the blog authors end.
CampaignId String


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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839