Info_Folders

Query Smartsheet Folders in the Sheets Folder for the User, in another Folder, or in a Workspace.

Table Specific Information

Retrieve all Folders.

SELECT * FROM Info_Folders

Retrieve details for a Folder.

SELECT * FROM Info_Folders WHERE Id='2035256120371076'

Retrieve Folders of a specified Workspace.

SELECT * FROM Info_Folders WHERE WorkspaceId = '2940085806098308'

Name	Type	References	Description
Id [KEY]	String		The unique identifier of the folder.
Name	String		The folder name.
Permalink	String		URL that represents a direct link to the Folder in Smartsheet.
Favorite	Boolean		Whether the user has marked the Folder as a Favorite in their Home tab.
WorkspaceId	String		Id of workspace where this folder is located