BlogAuthors

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	ReadOnly	References	Filterable	Description
Id [KEY]	String	True		True	The unique ID of the blog author.
Name	String	False		True	The name field for the blog author.
FullName	String	False		True	The full, unabbreviated name of the blog author, typically their first and last name combined.
DisplayName	String	False			The full name of the blog author to be displayed.
Email	String	False		True	Email address of the blog author.
Slug	String	False		True	A URL-friendly identifier for the blog author that can be used to reference the author in URLs.
Language	String	False		True	The explicitly defined ISO 639 language code of the blog author.
Bio	String	False			A short biography of the blog author.
Avatar	String	False			URL to the blog author's avatar, if supplying a custom one.
Website	String	False			URL to the website of the blog author.
Twitter	String	False			URL or username of the Twitter account associated with the blog author.
Facebook	String	False			URL to the blog author's Facebook page.
Linkedin	String	False			URL to the blog author's LinkedIn page.
Created	Datetime	True			The datetime when this blog author was created.
Updated	Datetime	True			The datetime when this blog author was updated.
DeletedAt	Datetime	True			The datetime when this blog author was deleted.
TranslatedFromId	Long	False			ID of the primary blog author this object was translated from.

Power BI Connector for HubSpot

BlogAuthors

Table Specific Information

SELECT

Columns