Blogs
Returns all blogs configured in HubSpot, offering visibility into blog structures and content.
Table Specific Information
SELECT
When selecting blogs, they can only be filtered by the Id, Name, and CreatedAt. CreatedAt can be used to specify a range. For example:
SELECT * FROM Blogs WHERE CreatedAt >= '1/1/2014' AND CreatedAt <= '10/31/2014' SELECT * FROM Blogs WHERE Name = 'myblog'
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | Unique identifier assigned to the blog record. | |
| Name | String | Internal name of the blog used for organizational and reference purposes. | |
| AllowComments | Boolean | Indicates whether comments are enabled for posts on the blog. | |
| CommentShouldCreateContact | Boolean | Determines whether commenters' email addresses not already in HubSpot should be automatically added as contacts. | |
| CreatedAt | Datetime | Timestamp indicating when the blog record was originally created. | |
| HTMLTitle | String | HTML title tag of the blog, displayed in the browser's title bar and search engine results. | |
| Language | String | Language setting of the blog, specifying the primary language used for content. | |
| PostsPerListingPage | Long | Number of blog posts displayed per page in the standard HTML blog view. | |
| PostsPerRSSFeed | Long | Number of blog posts included per page in the blog's RSS feed. | |
| PublicTitle | String | Public-facing header or title of the blog, visible to readers. | |
| RootURL | String | Full URL including domain and protocol where the blog is hosted. | |
| ShowSocialLinkFacebook | Boolean | Indicates whether a Facebook social sharing link should be displayed on the blog. | |
| ShowSocialLinkGoogle | Boolean | Indicates whether a Google Plus social sharing link should be displayed on the blog. | |
| ShowSocialLinkLinkedIn | Boolean | Indicates whether a LinkedIn social sharing link should be displayed on the blog. | |
| ShowSocialLinkTwitter | Boolean | Indicates whether a Twitter social sharing link should be displayed on the blog. | |
| Slug | String | URL path where the blog is accessible. | |
| UpdatedAt | Datetime | Timestamp indicating when the blog record was last updated. | |
| ExtraUrlParameters | String | Optional input-only property to specify additional query parameters when retrieving blog data. Format: 'param1=value1, param2=value2, param3=value3'. |