# SheetRows ## Documentation The rows of the sheets, without their values; the values are in SheetCells. A filter on sheet_id reads one sheet only. An insert adds an empty row at the bottom, a delete removes a row with its children. - Catalog: `Smartsheet` - Schema: `Sheets` - Primary Keys: `sheet_id, row_id` - Retrieve: True - Insert: True - Update: False - Delete: True ## Table Columns The columns of the table `SheetRows` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `created_at` | `datetime` | | ☐ | When the row was created, UTC. | | `expanded` | `char` | | ☐ | Whether the children of the row are shown. | | `filtered_out` | `char` | | ☐ | Whether the active filter of the sheet hides the row. | | `in_critical_path` | `char` | | ☐ | Whether the row is on the critical path of a project sheet. | | `locked` | `char` | | ☐ | Whether the row is locked against changes. | | `modified_at` | `datetime` | | ☐ | When the row was last changed, UTC. | | `parent_row_id` | `int64` | | ☐ | The row this row is indented below; null at the top level. | | `permalink` | `varchar2` | | ☐ | The link that opens the row in Smartsheet. | | `row_id` | `int64` | | ☑ | The id of the row. | | `row_number` | `int32` | | ☑ | The number of the row as the sheet shows it, starting at 1. | | `sheet_id` | `int64` | | ☑ | The sheet of the row. | | `sibling_row_id` | `int64` | | ☐ | The row directly above on the same level; null for the first child. | | `to_top` | `char` | | ☐ | Write only, on insert: add the row at the top instead of the bottom. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `sheet_id` | [[Sheets-Sheets\|Sheets.Sheets]] | `sheet_id` | Declared by the connector, not enforced by the platform | | `sheet_id`, `parent_row_id` | [[Sheets-SheetRows\|Sheets.SheetRows]] | `sheet_id`, `row_id` | Declared by the connector, not enforced by the platform | | `sheet_id`, `sibling_row_id` | [[Sheets-SheetRows\|Sheets.SheetRows]] | `sheet_id`, `row_id` | Declared by the connector, not enforced by the platform | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Sheets-SheetAttachments\|Sheets.SheetAttachments]] | `sheet_id`, `parent_id` | In words only: A row only when parent_type is ROW; otherwise the sheet or a comment. | | [[Sheets-SheetCells\|Sheets.SheetCells]] | `sheet_id`, `row_id` | Declared by the connector, not enforced by the platform | | [[Sheets-SheetCrossSheetReferences\|Sheets.SheetCrossSheetReferences]] | `source_sheet_id`, `end_row_id` | In words only: The last row of the range in the source sheet; null for whole columns. | | [[Sheets-SheetCrossSheetReferences\|Sheets.SheetCrossSheetReferences]] | `source_sheet_id`, `start_row_id` | In words only: The first row of the range in the source sheet; null for whole columns. | | [[Sheets-SheetDiscussions\|Sheets.SheetDiscussions]] | `sheet_id`, `parent_id` | In words only: A row only when parent_type is ROW; otherwise the sheet itself. | | [[Sheets-SheetRows\|Sheets.SheetRows]] | `sheet_id`, `parent_row_id` | Declared by the connector, not enforced by the platform | | [[Sheets-SheetRows\|Sheets.SheetRows]] | `sheet_id`, `sibling_row_id` | Declared by the connector, not enforced by the platform |