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 anyDescription
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" )Related functions
Other functions related to Smartsheet.Content are:
