# FolderItems ## Documentation Everything in the workspaces and their folders, at every depth: sheets, reports, dashboards and folders, each with where it is. - Catalog: `Smartsheet` - Schema: `Workspaces` - Primary Keys: `resource_type, id` This is a read-only table. The Smartsheet API may not support changing the data or the Invantive UniversalSQL driver for Smartsheet does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Smartsheet API. ## Table Columns The columns of the table `FolderItems` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `access_level` | `varchar2` | | ☐ | What the user may do with it. | | `created_at` | `datetime` | | ☐ | When it was created, UTC. | | `depth` | `int32` | | ☐ | 0 at the top of the workspace. | | `id` | `int64` | | ☑ | The id of the sheet, report, dashboard or folder. | | `modified_at` | `datetime` | | ☐ | When it was last changed, UTC. | | `name` | `varchar2` | | ☐ | The name. | | `parent_folder_id` | `int64` | | ☐ | The folder it is in; null at the top of the workspace. | | `permalink` | `varchar2` | | ☐ | The link that opens it in Smartsheet. | | `resource_type` | `varchar2` | | ☑ | What it is: sheet, report, sight (a dashboard) or folder. | | `workspace_id` | `int64` | | ☑ | The workspace it is in. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `id` | [[Sheets-Sheets\|Sheets.Sheets]] | `sheet_id` | In words only: A sheet when resource_type is sheet. | | `id` | [[Reports-Reports\|Reports.Reports]] | `report_id` | In words only: A report when resource_type is report. | | `id` | [[Reports-Dashboards\|Reports.Dashboards]] | `dashboard_id` | In words only: A dashboard when resource_type is sight. | | `id` | [[Workspaces-Folders\|Workspaces.Folders]] | `folder_id` | In words only: A folder when resource_type is folder. | | `parent_folder_id` | [[Workspaces-Folders\|Workspaces.Folders]] | `folder_id` | Declared by the connector, not enforced by the platform | | `workspace_id` | [[Workspaces-Workspaces\|Workspaces.Workspaces]] | `workspace_id` | Declared by the connector, not enforced by the platform |