ADO.NET Provider for HubSpot

Build 21.0.8137


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'


Name Type ReadOnly References Description
Id [KEY] Long True

The id of the blog post.

AuthorUserId Long False

The HubSpot user id of the blog author.

BlogAuthorId Long False


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

CampaignId String False


The guid of the marketing campaign this post is associated with.

ContentGroupId Long False

The id of the blog that this post belongs to. Get the id by looking at the blog API.

TopicIds String False

The individual topics the post is associated with.

CreatedAt Datetime True

When the post was first created.

DeletedAt Datetime True

When the post was deleted.

IsArchived Boolean True

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

Name String False

The internal name of the blog post.

Slug String False

The path of the URL on which the post will live.

UpdatedAt Datetime True

When the post was last updated.

PostSummary String False

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

PostBody String False

The HTML of the main post body.

Url String True

The full URL with domain and scheme to the blog post. Will return a 404 if the post is not yet published.

ExtraUrlParameters String True

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) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137