BlogAuthors

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.

SELECT

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'

Columns


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

ODBC Driver for HubSpot

BlogAuthors

Table Specific Information

SELECT

Columns