CommentsCData BizTalk Adapter for HubSpot 2019 - Build 19.0.7424
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'
|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.
|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'.|