Info_Comments

Access comments within discussions in Smartsheet, providing insights into collaboration history.

Table Specific Information

This view returns details for Columns of a specified Discussion. The SheetId parameter is always required.

Retrieve all comments from a sheet.

SELECT * FROM Info_Comments WHERE SheetId = '2940085806098308'

Retrieve details of a specified Comment.

SELECT * FROM Info_Comments WHERE SheetId = '2940085806098308' AND Id = '1322606759569284'

You can insert a comment to a discussion by providing SheetId, DiscussionId and Text.

INSERT INTO Info_Comments (SheetId, DiscussionId, Text) VALUES ('568679927703428', '4661021235275652', 'This is a comment 3')


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		A unique identifier assigned to each comment, ensuring it can be referenced distinctly.
Text	String	False		The main content of the comment, containing the user's input or feedback.
UserName	String	False		The name of the user who authored the comment, useful for identifying contributors.
UserEmail	String	False		The email address of the user who authored the comment, allowing for communication or verification.
CreatedAt	Datetime	False		The timestamp indicating when the comment was originally created.
ModifiedAt	Datetime	False		The timestamp indicating the most recent update or edit made to the comment.
AttachmentsAggregate	String	False		A serialized array of attachment objects associated with the comment, providing access to related files.
DiscussionId	String	False		The unique identifier of the discussion thread to which the comment belongs.
SheetId	String	False		The unique identifier of the sheet where the comment is located.