Power BI Connector for Smartsheet

Build 23.0.8839


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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839