BlogAuthors
Fetches a list of blog authors registered in HubSpot, helpful for managing and attributing blog content.
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 | Unique identifier assigned to the blog author. | |
| FullName | String | The full name of the blog author, including both first and last names. | |
| CreatedAt | Datetime | Timestamp indicating when the blog author record was first created in HubSpot. | |
| Slug | String | URL-friendly path appended to the blog URL where the author's profile page is accessible. | |
| DeletedAt | Datetime | Timestamp indicating when the blog author was marked as deleted, if applicable. | |
| String | Email address associated with the blog author for identification or contact. | ||
| FacebookProfile | String | URL of the blog author's Facebook profile page. | |
| GooglePlusProfile | String | URL of the blog author's Google Plus profile page. | |
| LinkedInProfile | String | URL of the blog author's LinkedIn profile page. | |
| TwitterProfile | String | Twitter handle of the blog author, typically used for social media linking. | |
| AvatarUrl | String | URL of the author's avatar image, typically a small profile photo. | |
| UserId | Long | HubSpot user ID linked to the blog author account. | |
| Username | String | HubSpot username linked to the blog author's account. | |
| Website | String | URL of the blog author's personal or professional website. | |
| UpdatedAt | Datetime | Timestamp indicating the last time the blog author's record was updated. | |
| ExtraUrlParameters | String | Optional input-only parameter to specify additional query parameters when retrieving blog author data. Format: 'param1=value1, param2=value2, param3=value3'. |