JDBC Driver for Smartsheet

Build 22.0.8462

Info_Folders

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

Table Specific Information

Select

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'

Columns

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462