Info_Objects
Returns Smartsheet objects, including sheets, reports, dashboards, templates, and folders.
Table-specific Information
SELECT
Retrieve all objects.
SELECT * FROM Info_Objects
Retrieve objects of a specific type.
SELECT * FROM Info_Objects WHERE Type = 'folder';
SELECT * FROM Info_Objects WHERE Type IN ('folder', 'dashboard');
Retrieve objects located directly on a specific folder, or set of folders. Unlike RootFolderId below, this does not return objects nested in subfolders.
SELECT * FROM Info_Objects WHERE FolderId = '2928085806875091';
SELECT * FROM Info_Objects WHERE FolderId = '2928085806875091' AND Type IN ('folder', 'dashboard');
SELECT * FROM Info_Objects WHERE FolderId IN ('2928085806875091', '2928085806875092');
Retrieve objects located on a specific workspace.
SELECT * FROM Info_Objects WHERE WorkspaceId = '1928085806875098';
SELECT * FROM Info_Objects WHERE WorkspaceId = '1928085806875098' AND Type IN ('folder', 'dashboard');
Retrieve objects which are located beneath the folder specified in the folder hierarchy. Only simple criteria like the ones below can be processed for this pseudo-column, otherwise the condition will just be ignored:
SELECT * FROM Info_Objects WHERE RootFolderId = '993868452784004';
SELECT * FROM Info_Objects WHERE RootFolderId = '993868452784004' AND Name = 'MyTemplate';
SELECT * FROM Info_Objects WHERE RootFolderId = '993868452784004' AND Type IN ('folder', 'dashboard');
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier of the object. | |
| Name | String | The name of the object. | |
| Type | String | The type of the object, such as sheet, report, dashboard, template, or folder. | |
| AccessLevel | String | The permission level of the current user for this object, such as 'viewer', 'editor', or 'admin'. | |
| Permalink | String | URL that represents a direct link to the object in Smartsheet. | |
| CreatedAt | Datetime | The time when the object was created. | |
| ModifiedAt | Datetime | The time when the object was last modified. | |
| FolderId | String |
Info_Folders.Id | The unique identifier of the folder where the object is stored. Filtering on this column returns only the objects directly within the specified folder(s), unlike RootFolderId which also returns objects in nested subfolders. |
| WorkspaceId | String | The unique identifier of the workspace containing the object. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| RootFolderId | String | The Id of the root folder in which the object resides. Can be used to query the data from only a specific folder (and its subfolders) in the Smartsheet hierarchy. |