External DocumentationTo learn more, visit the Smartsheet documentation.
Basic Parameters
| Parameter | Description |
|---|---|
| Exclude | A comma-separated list of element types to exclude from the response: - Filtered out Rows - excludes filtered-out rows from response payload if a sheet filter is applied; includes total number of filtered rows.- Link in from cell Details - excludes the following attributes from the cell.linkInFromCell object: columnId, rowId, status.- Links Out To Cells Details - excludes the following attributes from the cell.linksOutToCells array elements: columnId, rowId, status.- None existent cells - excludes empty cells. |
| Include | A comma-separated list of elements to include in the response. * The columns flag adds a columns array that specifies all of the columns for the sheet.* The filters flag returns a filteredOut attribute indicating if the row should be displayed or hidden according to the sheet’s filters. |
| Row ID | Row ID of the row being accessed. Can be obtained by using List Search Sheet or Search Sheets actions. |
| Sheet ID | Sheet ID of the sheet being accessed. |
Advanced Parameters
| Parameter | Description |
|---|---|
| Level | Specifies whether object data types, such as multi-contact data are returned in a backwards-compatible, text format in text/number columns. - Set level=0 (default) to use text/number columns for multi-contact data and multi-picklist data.- Set level=1 to use multiple-entry contact list columns for multi-contact data; multi-picklist data is returned in text/number columns.- Set level=2 to use multiple-entry contact list columns for multi-contact data and use multiple-entry picklist columns for multi-picklist data. |
Example Output
{
"id": 940739534558112,
"sheetId": 3122331708376523,
"rowNumber": 3,
"siblingId": 3216544120087153,
"version": 5,
"expanded": false,
"accessLevel": "<string>",
"createdAt": "2025-03-20T15:43:56Z",
"modifiedAt": "2025-04-01T05:15:12Z",
"cells": [
{
"columnId": 10584827567992126,
"value": "<string>",
"displayValue": "<string>"
},
{
"columnId": 2819589684621389,
"value": "<string>",
"displayValue": "<string>"
}
],
"columns": [
{
"id": 5438043066574469,
"version": 2,
"index": 2,
"title": "<string>",
"type": "<string>",
"primary": true,
"validation": false,
"width": 99
},
{
"id": 5999549488869523,
"version": 0,
"index": 1,
"title": "<string>",
"type": "<string>",
"validation": false,
"width": 124
}
]
}
Workflow Library Example
Get Row with Smartsheet and Send Results Via Email