JDBC Driver for Smartsheet

Build 22.0.8462

Info_Comments

Query Smartsheet Comments in a Discussion.

Table Specific Information

Select

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'

Insert

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')

Columns

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462