Comments
This view represents comments within SharePoint, detailing their authors, content, replies, and associated metadata.
Columns
| Name | Type | References | Description |
| Id [KEY] | Int | A unique identifier for each comment. | |
| ItemId [KEY] | Int |
ListItems.Id | The ID of the item associated with the comment. |
| List | String |
Lists.Title | The name of the SharePoint list containing the item and its comments. |
| ListId | String | The unique ID of the list the comment belongs to. | |
| AuthorId | Int | The unique identifier of the comment's author. | |
| AuthorEmail | String | The email address of the comment's author. | |
| IsReply | Bool | Indicates whether the comment is a reply to another comment. | |
| ParentId | Int |
Comments.Id | The unique ID of the parent comment if this is a reply. |
| ReplyCount | Int | The total number of replies to the comment. | |
| LikeCount | Int | The total number of likes on the comment. | |
| IsLikedByUser | Bool | Indicates whether the comment is liked by the current user. | |
| Text | String | The text content of the comment. | |
| Mentions | String | A list of users mentioned in the comment, if any. | |
| CreatedDate | Datetime | The date and time when the comment was originally created. | |
| ModifiedDate | Datetime | The date and time when the comment was last modified. |