​
Get Row

Gets the row specified in the URL.

External Documentation

To learn more, visit the Smartsheet documentation.

​
Basic Parameters

ParameterDescription
ExcludeA 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.
IncludeA 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 IDRow ID of the row being accessed. Can be obtained by using List Search Sheet or Search Sheets actions.
Sheet IDSheet ID of the sheet being accessed.

​
Advanced Parameters

ParameterDescription
LevelSpecifies 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

{
	"cells": [
		{
			"columnId": 0,
			"columnType": "Only returned if the include query string parameter contains **columnType**.",
			"displayValue": "Visual representation of cell contents, as presented to the user in the UI.",
			"value": "string"
		}
	],
	"createdAt": "date-time",
	"expanded": false,
	"id": 0,
	"modifiedAt": "date-time",
	"rowNumber": 0,
	"sheetId": 0
}

​
Workflow Library Example

Get Row with Smartsheet and Send Results Via Email

Preview this Workflow on desktop

Was this page helpful?

OverviewList Columns