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, IsArchived, CampaignId, ContentGroupId, CreatedAt, DeletedAt, Name, Slug, and UpdatedAt columns. CreatedAt, DeletedAt, 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 DeletedAt >= '1/1/2014' SELECT * FROM BlogPosts WHERE Name LIKE 'My Post'
The id of the blog post.
The HubSpot user id of the blog author.
The integer id of the blog author, look up via the blog authors end.
The guid of the marketing campaign this post is associated with.
The id of the blog that this post belongs to. Get the id by looking at the blog API.
The individual topics the post is associated with.
When the post was first created.
When the post was deleted.
If True, the post will not show up in your dashboard, although the post will still be live.
The internal name of the blog post.
The path of the URL on which the post will live.
When the post was last updated.
The summary of the blog post that will appear on the main listing page.
The HTML of the main post body.
The full URL with domain and scheme to the blog post. Will return a 404 if the post is not yet published.
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'.