Read All Rows

Read All Rows

Reads all rows from a sheet and returns all rows in the sheet as a list of objects.

Note: This action will read all columns regardless of column output(s) selected.

Options

  • Your Smartsheet sheets (dropdown list): A list of all available Smartsheet sheets associated with your Smartsheet account. You can also select --Insert ID-- to define the sheet as an input.

Input Fields

Sheet ID (only if you selected --Sheet ID-- in options) (text): the ID of the sheet you want to read.

Output Fields

Outputs

  • Rows(list): A list of 'Row' objects. Each object includes:

    • Row ID(text): The ID of the row.

    • Row Number(text): The number of the row as it appears in Smartsheet.

    • Columns(object): A dynamically generated object containing the values from each column in the row.

    • There is an additional option to include more information in the column objects, accessible by using the "Enter key name here" field. If you don't have a reason to include additional information, it is unlikely that you need to use the additional field. All columns will be read regardless of using this field.

    • There is an additional option to include more information in the row objects, accessible by using the "Enter key name here" field. If you don't have a reason to include additional information, it is unlikely that you need to use the additional field.

See also