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

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'


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.