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