Query Smartsheet Dashboards.

Table-specific Information

The RootFolderId pseudo-column is NOT present when UseLegacyAPI is enabled.

SELECT

Retrieve all dashboards.

SELECT * FROM Info_Dashboards

Retrieve dashboards located on a specific folder.

SELECT * FROM Info_Dashboards WHERE FolderId = '2928085806875091'

Retrieve dashboards located on a specific workspace.

SELECT * FROM Info_Dashboards WHERE WorkspaceId = '1928085806875098'

Retrieve dashboards 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_Dashboards WHERE RootFolderId = '993868452784004';
SELECT * FROM Info_Dashboards WHERE RootFolderId = '993868452784004' AND Name = 'MyTemplate';

Columns

Name	Type	References	Description
Id [KEY]	String		The unique identifier of the Dashboard.
Name	String		The name of the Dashboard.
AccessLevel	String		The access level for the user or group on the shared object.
Permalink	String		URL that represents a direct link to the Dashboard in Smartsheet.
CreatedAt	Datetime		Time that the share was created.
ModifiedAt	Datetime		Time that the share was modified.
WorkspaceId	String		Id of workspace where this Dashboard is located. DEPRECATED, to be removed in the next major release.
FolderId	String		The Id of the folder. DEPRECATED, to be removed in the next major release.

Pseudo-Columns

Pseudo column 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 object resides. Can be used to query the data from only a specific folder (and its subfolders) in the Smartsheet hierarchy. DEPRECATED, to be removed in the next major release.