Smartsheet
Add Smartsheet row details to Google Sheets on QR scan
This query returns the full details of a specific row in a Smartsheet sheet, looked up by row ID.
Developer info
- API endpoint slug
- smartsheet.look_up_row_by_id
- Runtime method
- performQuery("smartsheet.look_up_row_by_id"}
Query fields
Sheet Dropdown list
- Label
- Sheet
- Helper text
- Choose the sheet containing the row.
- Slug
- sheet
- Required
- true
- Can have default value
- false
Row Text input > Other
- Label
- Row ID
- Helper text
- The numeric ID of the row to look up.
- Slug
- row_id
- Required
- true
- Can have default value
- true
Ingredients
Row
- Slug
- row_id
- Filter code
- Smartsheet.lookUpRowById.RowId
- Type
- String
- Example
- 8901234567890123
Sheet
- Slug
- sheet_id
- Filter code
- Smartsheet.lookUpRowById.SheetId
- Type
- String
- Example
- 1234567890123456
Sheet name
- Slug
- sheet_name
- Filter code
- Smartsheet.lookUpRowById.SheetName
- Type
- String
- Example
- Q2 Roadmap
Row number
- Slug
- row_number
- Filter code
- Smartsheet.lookUpRowById.RowNumber
- Type
- String
- Example
- 42
Column values
- Slug
- column_values
- Filter code
- Smartsheet.lookUpRowById.ColumnValues
- Type
- String
- Example
- Task: Ship v2 | Owner: jane@example.com | Status: In Progress
Created at
- Slug
- created_at
- Filter code
- Smartsheet.lookUpRowById.CreatedAt
- Type
- Date with time (ISO8601)
- Example
- 2020-07-08T04:17:06+05:00
Modified at
- Slug
- modified_at
- Filter code
- Smartsheet.lookUpRowById.ModifiedAt
- Type
- Date with time (ISO8601)
- Example
- 2020-07-08T04:17:06+05:00
Row url
- Slug
- row_url
- Filter code
- Smartsheet.lookUpRowById.RowUrl
- Type
- Web URL
- Example
- https://app.smartsheet.com/sheets/1234567890123456?rowId=8901234567890123
