Comments

Retrieve the available comments from your blog in HubSpot.

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		The id of the comment.
State	String		The current state of the comment. The allowed values are APPROVED, SPAM, REJECTED, PENDING_MODERATION.
PostId	Long	BlogPosts.Id	The id of the parent blog post.
Comment	String		The full text of the comment.
CommentAuthorEmail	String		Email address of the user submitting the comment.
CommentAuthorName	String		Name of the user submitting the comment.
ContentPermalink	String		A permanent link for the parent post of the comment.
ContentTitle	String		The title of the parent post for the comment.
CreatedAt	Datetime		When the comment was made.
DeletedAt	Datetime		When the comment was deleted.
FirstName	String		The first name of the user who made the comment.
LastName	String		The last name of the user who made the comment.
UserEmail	String		Email address of the user submitting the comment.
UserUrl	String		A url to the user's website if available.
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'.