Skip to main content

Smartsheet.Query

Returns a JSON result from the Smartsheet API

Syntax​

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

Remarks​

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

Examples​

Example #1​

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

Smartsheet.Content("sheets", "include=ownerInfo&includeAll=true", [])

Result:

A table with sheets information as returned by the Smartsheet API