Comments

Retrieves comments submitted on HubSpot blog posts, useful for engagement monitoring and moderation.

Table Specific Information

Comments represent any comments that can be made on a given blog post.

When selecting comments, they can only be filtered by the Id, State, PostId, and Comment. Comment can be used with the LIKE comparison. For example:

SELECT * FROM Comments WHERE Comment LIKE 'comment text'
SELECT * FROM Comments WHERE Id = '123456789'


Name	Type	References	Description
Id [KEY]	Long		Unique identifier assigned to the comment record.
State	String		Current moderation state of the comment, such as approved or pending. The allowed values are APPROVED, SPAM, REJECTED, PENDING_MODERATION.
PostId	Long	BlogPosts.Id	Identifier of the parent blog post to which the comment belongs.
Comment	String		Full text content submitted as the comment.
CommentAuthorEmail	String		Email address provided by the user who submitted the comment.
CommentAuthorName	String		Name provided by the user who submitted the comment.
ContentPermalink	String		Permanent URL link to the parent blog post associated with the comment.
ContentTitle	String		Title of the blog post where the comment was made.
CreatedAt	Datetime		Timestamp indicating when the comment was created.
DeletedAt	Datetime		Timestamp indicating when the comment was deleted, if applicable.
FirstName	String		First name of the user who submitted the comment, if provided.
LastName	String		Last name of the user who submitted the comment, if provided.
UserEmail	String		Email address of the user who submitted the comment (duplicate of CommentAuthorEmail).
UserUrl	String		URL of the user's personal or professional website, if provided.
ExtraUrlParameters	String		Optional input-only property to specify additional query parameters when retrieving comment data. Format: 'param1=value1, param2=value2, param3=value3'.