Query Smartsheet reports, providing insights into custom aggregated data across sheets.

Table Specific Information

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

Select

Retrieve all Reports.

SELECT * FROM Info_Reports

Retrieve Reports located in a specific Workspace.

SELECT * FROM Info_Reports WHERE WorkspaceId = '6773684447799172'

Retrieve Reports located in a specific Folder.

SELECT * FROM Info_Reports WHERE FolderId = '6773684447799172'

Retrieve Reports 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_Reports WHERE RootFolderId = '993868452784004';
SELECT * FROM Info_Reports WHERE RootFolderId = '993868452784004' AND Name = 'MyReport';

Columns

Name	Type	References	Description
Id [KEY]	String		A unique identifier for the report, used as the primary key for reference.
Name	String		The descriptive name of the report, typically used to identify its purpose or content.
FolderId	String		The unique identifier of the folder where the report is stored, indicating its organizational structure.
WorkspaceId	String		The unique identifier of the workspace containing this report, representing its broader context and ownership.
Permalink	String		URL that represents a direct link to the report in Smartsheet.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are 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.