Comments
Contains details about comments made on SharePoint items, including authorship, content, replies, and metadata. Useful for monitoring discussions and user interactions.
Columns
| Name | Type | References | Description |
| Id [KEY] | Int | A unique numeric identifier for each comment. Useful for referencing specific comments in workflows or API queries. | |
| ItemId [KEY] | Int |
ListItems.Id | The ID of the SharePoint item that the comment is associated with. Helps link comments to their respective list items. |
| List | String |
Lists.Title | The name of the SharePoint list that contains the commented item. Useful for identifying the list context of the comment. |
| ListId | String | A unique identifier for the SharePoint list containing the comment. Helps differentiate between lists when retrieving comments. | |
| AuthorId | Int | The unique identifier of the user who authored the comment. Useful for tracking authorship and permissions. | |
| AuthorEmail | String | The email address of the user who posted the comment. Helps identify and contact the commenter. | |
| IsReply | Bool | Indicates whether the comment is a reply to another comment. Useful for structuring threaded discussions. | |
| ParentId | Int |
Comments.Id | The ID of the parent comment if this comment is a reply. Helps maintain comment hierarchy in nested conversations. |
| ReplyCount | Int | The total number of replies to the comment. Useful for tracking engagement and discussion activity. | |
| LikeCount | Int | The total number of likes the comment has received. Helps measure comment popularity. | |
| IsLikedByUser | Bool | Indicates whether the current user has liked the comment. Useful for personalizing user interactions. | |
| Text | String | The full text content of the comment. Essential for displaying the comment in user interfaces. | |
| Mentions | String | A list of users mentioned in the comment, separated by commas. Useful for notifying users mentioned in discussions. | |
| CreatedDate | Datetime | The date and time when the comment was originally posted. Useful for tracking comment history. | |
| ModifiedDate | Datetime | The date and time when the comment was last edited. Helps in auditing changes and tracking updates. |