Comments

Create, read, update and delete the comments.

Table-Specific Information

The connector processes all filters client-side within the connector. The following queries are the only ones processed server-side:

SELECT * FROM Comments WHERE Id = '123'

You must specify Article Id, Author, Body, Email to create a Comment.

INSERT INTO Comments (articleid, author, body, email) VALUES ('5557001', 'Harry', 'test', '[email protected]')

You must specify the Id to update a Comment. For example:

UPDATE Comments SET Author = 'Adam' WHERE Id = '77171130'

You must specify the Id of the Comments to delete it.

DELETE FROM Comments WHERE Id = '555695'


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the comment.
BlogId	Long	False	Blogs.Id	A unique numeric identifier for the blog containing the article that the comment belongs to.
ArticleId	Long	False	Articles.Id	A unique numeric identifier for the article that the comment belongs to.
Author	String	False		The name of the author of the comment.
Body	String	False		The basic Textile markup of a comment.
BodyHtml	String	False		The text of the comment, complete with HTML markup.
CreatedAt	Datetime	True		The date and time (ISO 8601 format) when the comment was created.
Email	String	False		The email address of the author of the comment.
Ip	String	False		The IP address from which the comment was posted.
PublishedAt	String	False		The date and time (ISO 8601 format) when the comment was published.
Status	String	True		The status of the comment.
UpdatedAt	Datetime	True		The date and time (ISO 8601 format) when the comment was last modified.
UserAgent	String	False		The user agent string provided by the software used to create the comment.
PublishedStatus	String	False		Filter comments by their publish status. Valid values are: published, unpublished and any ; default: any.