JDBC Driver for HubSpot

Build 22.0.8462

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.

Select

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'

Columns

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462