Read and write discussions data on your Smartsheet sheets.

Table-specific Information

SELECT

This table returns a list of discussions. The SheetId column is always required.

Retrieve all discussions in a sheet.

SELECT * FROM Info_Discussions WHERE SheetId = '2940085806098308'

Retrieve all discussions in a specific row of a sheet.

SELECT * FROM Info_Discussions WHERE SheetId = '2940085806098308' AND RowId = '6773684447799172'

Retrieve details of a specified discussion.

SELECT * FROM Info_Discussions WHERE SheetId = '2940085806098308' AND Id = '8206230771525508'

INSERT

You can insert a discussion into a sheet by providing the SheetId and FirstDiscussionComment columns. To add a discussion to a row in the sheet instead, provide the RowId, SheetId, and FirstDiscussionComment columns. Refer to the following query examples:

INSERT INTO Info_Discussions (SheetId, FirstDiscussionComment) VALUES ('568679927703428', 'This is a comment 1')
INSERT INTO Info_Discussions (RowId, SheetId, FirstDiscussionComment) VALUES ('1889077216995204', '568679927703428', 'This is a comment 2')

DELETE

You can delete a discussion in the sheet by specifying the SheetId and Id columns in the criteria as shown in the following example query:

DELETE FROM Info_Discussions WHERE SheetId = '8449165781585796' AND Id = '5354407478988676'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		A unique identifier for the discussion within the Smartsheet.
Title	String	False		The subject or headline of the discussion, providing a brief summary of its content.
AccessLevel	String	False		Indicates the user's permission level for accessing the discussion (for example, view, edit).
ParentId	String	False		The unique identifier of the row or sheet directly associated with the discussion.
ParentType	String	False		Specifies whether the discussion is linked to a row or a sheet. Possible values include: SHEET or ROW.
LastCommentedAt	Datetime	False		The timestamp indicating when the most recent comment was added to the discussion.
LastCommentBy	String	False		The full name of the user who made the latest comment in the discussion.
CreatorName	String	False		The full name of the user who initiated the discussion.
ReadOnly	Boolean	False		Indicates if the discussion is in a read-only state, preventing any modifications.
SheetId	String	False		The unique identifier of the sheet where the discussion is located.
RowId	String	False		The unique identifier of the row associated with the discussion.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
FirstDiscussionComment	String	A special input-only field for adding the initial comment to a new discussion.