Read and write folders data in your Smartsheet account.

Table-specific Information

SELECT

Retrieve all folders.

SELECT * FROM Info_Folders

Retrieve details for a specific folder, or a set of folders.

SELECT * FROM Info_Folders WHERE Id = '2035256120371076'
SELECT * FROM Info_Folders WHERE Id IN ('2035256120371076', '2035256120371077')

Retrieve all folders in a specific workspace.

SELECT * FROM Info_Folders WHERE WorkspaceId = '2940085806098308'

Retrieve the direct subfolders of a specific folder, or set of folders. Unlike RootFolderId below, this does not return subfolders nested further down the hierarchy.

SELECT * FROM Info_Folders WHERE ParentFolderId = '5465554459879300'
SELECT * FROM Info_Folders WHERE ParentFolderId IN ('5465554459879300', '5465554459879301')

Retrieve all folders 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_Folders WHERE RootFolderId = '993868452784004';
SELECT * FROM Info_Folders WHERE RootFolderId = '993868452784004' AND Name = 'MyFolder';

INSERT

You can create a folder inside a workspace or a parent folder by providing either the WorkspaceId column or the ParentFolderId column, and the Name column as shown in the example queries below.

INSERT INTO Info_Folders (WorkspaceId, Name) VALUES ('609757951223684', 'My Folder 1')
INSERT INTO Info_Folders (ParentFolderId, Name) VALUES ('5465554459879300', 'My Folder 1')

UPDATE

You can update folder data by specifying the Id column in the criteria as shown in the example query below.

UPDATE Info_Folders SET Name = 'My Test Folder 1' WHERE Id = '2035256120371076'

DELETE

You can delete a folder by specifying the Id column in the criteria as shown in the example query below.

DELETE FROM Info_Folders WHERE Id = '2035256120371076'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The unique identifier of the folder.
Name	String	False		The folder name.
Permalink	String	True		URL that represents a direct link to the folder in Smartsheet.
WorkspaceId	String	False	Info_Workspaces.Id	The unique identifier of the workspace that contains this folder, useful for context within a workspace hierarchy.
ParentFolderId	String	False	Info_Folders.Id	The unique identifier of the parent folder where the folder is stored, indicating its organizational structure. Filtering on this column returns only the direct subfolders of the specified folder(s), unlike RootFolderId which also returns subfolders nested further down the hierarchy.
CreatedAt	Datetime	True		The time when the folder was created.
ModifiedAt	Datetime	True		The time when the folder was last modified.

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 folder resides. Can be used to query the data from only a specific folder (and its subfolders) in the Smartsheet hierarchy.