JDBC Driver for HubSpot

Build 26.0.9770

Comments

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

Columns

Name Type References Filterable Description
Id [KEY] String True Unique identifier assigned to the comment record.
State String True Current moderation state of the comment, such as approved or pending.

The allowed values are APPROVED, SPAM, REJECTED, PENDING_MODERATION.

PostId String

BlogPosts.Id

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

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770