Comments
Contains details about comments made on SharePoint items, including authorship, content, replies, and metadata. Useful for monitoring discussions and user interactions.
View-Specific Information
To retrieve records from the Comments view, you must specify both the List and ItemId columns. These identify the list item whose comments you want to access.
Sample Query
The following query retrieves comments for the item with ItemId = 1 in the list1 list:
SELECT * FROM CData.REST.Comments WHERE List = 'list1' AND ItemId = 1;
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. |