Info_Comments

Query Smartsheet Comments in a Discussion.

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		The unique identifier of the comment.
Text	String	False		The comment body.
UserName	String	False		The user name.
UserEmail	String	False		The email address of the user.
CreatedAt	Datetime	False		The time of creation.
ModifiedAt	Datetime	False		The time of the last modification.
AttachmentsAggregate	String	False		Array of attachment objects.
DiscussionId	String	False		The Id of the discussion.
SheetId	String	False		The Id of the sheet.