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 on a specific folder.
SELECT * FROM Info_Objects WHERE FolderId = '2928085806875091';
SELECT * FROM Info_Objects WHERE FolderId = '2928085806875091' AND Type IN ('folder', 'dashboard');
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. |
| WorkspaceId | String | The unique identifier of the workspace containing the object. |
Pseudo-Columns
Pseudo column 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. |