Read and write comment data on your Smartsheet sheets.

Table-Specific Information

SELECT

This table returns details for comments in a sheet. The SheetId column is always required and must be specified in the criteria.

Retrieve all comments from a sheet.

SELECT * FROM Info_Comments WHERE SheetId = '2940085806098308';
SELECT * FROM Info_Comments WHERE SheetId IN ('2940085806098308', '8075134644473732');

Retrieve all comments from a specific discussion in the sheet.

SELECT * FROM Info_Comments WHERE SheetId = '2940085806098308' AND DiscussionId = '8206230771525508'

Retrieve a specific comment in the sheet.

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

INSERT

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

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

UPDATE

You can update the text of a comment in the sheet by specifying the SheetId and Id columns in the criteria as shown in the example query below.

UPDATE Info_Comments SET Text = 'My Comment.' WHERE SheetId = '2736916857677700' AND Id = '3641651486822276'

DELETE

You can delete a comment in the sheet by specifying the SheetId and Id columns in the criteria as shown in the example query below.

DELETE FROM Info_Comments WHERE SheetId = '2736916857677700' AND Id = '3641651486822276'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		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	True		The name of the user who authored the comment, useful for identifying contributors.
UserEmail	String	True		The email address of the user who authored the comment, allowing for communication or verification.
CreatedAt	Datetime	True		The timestamp indicating when the comment was originally created.
ModifiedAt	Datetime	True		The timestamp indicating the most recent update or edit made to the comment.
AttachmentsAggregate	String	True		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.