Smartsheet.Query

Updated on

Smartsheet.Query is a Power Query M function that makes a call to the Smartsheet 2.0 REST API at the specified endpoint and returns results as a JSON record.

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

Syntax

Smartsheet.Query(
   endpoint as text,
   args as text,
   headers as record,
) as any

Description

Makes a call to the Smartsheet 2.0 REST API at the specified endpoint and returns results as a JSON record.

Examples

Pulls data from the sheets Smartsheet API endpoint with additional arguments specified

// Output: A table with sheets information as returned by the Smartsheet API
Smartsheet.Content( "sheets", "include=ownerInfo&includeAll=true", [] )

Other functions related to Smartsheet.Query are:

Contribute » | Contributors: Rick de Groot