Smartsheet.Content

Updated on

Smartsheet.Content is a Power Query M function that makes a call to the Smartsheet 2.0 REST API at the specified endpoint and transforms the data element returned into a table.

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

Syntax

Smartsheet.Content( endpoint as text ) as any

Description

Makes a call to the Smartsheet 2.0 REST API at the specified endpoint and transforms the data element returned into a table.

Examples

Pulls a table of users information from the Smartsheet API

// Output: A table with users information as returned by the Smartsheet API
Smartsheet.Content( "users" )

Other functions related to Smartsheet.Content are:

BI Gorilla Youtube Channel

Contribute » | Contributors: Rick de Groot