Smartsheet.Tables

Updated on

Smartsheet.Tables is a Power Query M function that returns a nested table of available sheets, reports, folders, and workspaces from the Smartsheet API.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Smartsheet.Tables() as table

Description

Returns a nested table of available sheets, reports, folders, and workspaces from the Smartsheet API.

Examples

Returns sheets, folders, reports, and workspaces available at the top level of the Smartsheet hierarchy

// Output: A table of folders, reports, and workspaces from the top level of the Smartsheet hierarchy
Smartsheet.Tables()

Other functions related to Smartsheet.Tables are:

Contribute » | Contributors: Rick de Groot