ODBC Driver for HubSpot

Build 23.0.8839


Retrieve the available blog authors in HubSpot.

Table Specific Information

Blog authors represent the users in your HubSpot Hub that can make posts on your HubSpot blog.


When selecting blog authors, they can only be filtered by the Id, FullName, CreatedAt, or Slug. CreatedAt can be used to specify a range while the others must be used with an exact comparison. For example:

SELECT * FROM BlogAuthors WHERE CreatedAt >= '1/1/2014' AND CreatedAt <= '10/31/2014'
SELECT * FROM BlogAuthors WHERE Slug = 'abc123'


Name Type References Description
Id [KEY] Long The id of the author.
FullName String The first and last name of the blog author.
CreatedAt Datetime When the blog author was first created.
Slug String The path appended to the blog URL at which the author page will live.
DeletedAt Datetime When the author was deleted.
Email String The email address of the blog author.
FacebookProfile String The blog author's Facebook page.
GooglePlusProfile String The blog author's Google Plus profile.
LinkedInProfile String The blog author's LinkedIn profile
TwitterProfile String The blog author's twitter handle.
AvatarUrl String A small photo or image of the blog author.
UserId Long The HubSpot user id of the blog author.
Username String The HubSpot username of the blog author.
Website String The blog author's web site.
UpdatedAt Datetime When the blog author was last updated.
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