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. |