Search Rows by Column

Search for a row or rows that match a value in a certain column.


Field Definition Type Required
Workbook A list of workbooks available to the account. Workbook is another word for your Excel files. Dropdown FALSE
Worksheet A list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files. Dropdown FALSE
Column to Search The column the search will be conducted on. Dropdown FALSE
Result Set Either the first matching row or all matching rows. Dropdown FALSE


Field Definition Type Required
Value The column value. This is the number displayed in Excel on the top of first row. String FALSE


Field Definition Type
Result Matching row/list of rows. String
Row ID Unique identifier of the row. Number

Related topics

Excel Online connector

About the elements of Okta Workflows

Excel Online API documentation