JDBC Driver for Smartsheet

Build 22.0.8462

Info_Rows

Query Rows in a Sheet or Report. Each Row is composed of a collection of Cells, and may optionally contain Discussions and Attachments.

Table Specific Information

Select

This view returns a list of Sheet Rows. The SheetId parameter is always required.

Retrieve all Rows of a Sheet.

SELECT * FROM Info_Rows WHERE SheetId = '2940085806098308'

Retrieve details of a specified Row.

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

Columns

Name Type References Description
Id [KEY] String The unique identifier of the row.
RowNumber Integer The row number within the sheet. Starts at 1.
Version Integer The version number. This is incremented every time a sheet is modified.
FilteredOut Boolean True if this row is filtered out by a column filter (and thus is not displayed in the Smartsheet app). False if the row is not filtered out.
InCriticalPath Boolean True if the sheet is a project sheet with dependencies enabled and this row is in the critical path.
Locked Boolean Whether the row has been locked by the sheet owner or the admin.
LockedForUser Boolean Whether the row is locked for the requesting user.
Expanded Boolean Whether the row is expanded or collapsed.
AccessLevel String The permissions the user has to access the sheet that contains the row.
Format String The format descriptor.
ConditionalFormat String The format descriptor for a conditional filter.
CreatedAt Datetime Time of creation.
ModifiedAt Datetime Time of the last modification.
Permalink String URL that represents a direct link to the row in Smartsheet.
ParentId String The Id of the parent row.
SiblingId String The Id of the previous sibling row at the same hierarchical level of this row.
ToTop Boolean Flag used to specify the location for a new or moved row.
ToBottom Boolean Flag used to specify the location for a new or moved row.
Above Boolean Flag used to specify the location for a new or moved row.
SheetId String The Id of the parent sheet.

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