Read and write folders data in your Smartsheet account.

Table-specific Information

The RootFolderId pseudo-column and the CreatedAt, ModifiedAt columns are NOT present when UseLegacyAPI is enabled.

SELECT

Retrieve all folders.

SELECT * FROM Info_Folders

Retrieve details for a specific folder.

SELECT * FROM Info_Folders WHERE Id = '2035256120371076'

Retrieve all folders in a specific workspace.

SELECT * FROM Info_Folders WHERE WorkspaceId = '2940085806098308'

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		A system-generated unique identifier for the folder, used to reference it programmatically.
Name	String	False		The user-defined name of the folder, typically representing its content or purpose.
Permalink	String	True		A direct, shareable URL linking to the folder within Smartsheet, useful for quick access.
Favorite	Boolean	True		Indicates whether the user has marked the folder as a favorite for easier navigation in their Home tab.
WorkspaceId	String	False		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.
CreatedAt	Datetime	True		The time when the folder was created.
ModifiedAt	Datetime	True		The time when the folder was last modified.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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.