Actions
Get Row
Gets the row specified in the URL.
External Documentation
To 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
Workflow Library Example
Get Row with Smartsheet and Send Results Via Email
Preview this Workflow on desktop
Was this page helpful?