Aisello Database icon

Aisello Database

Interact with Aisello Database (Airtable-like tables)

Actions32

Row → Get

AI-generated

Summary

Retrieve a single row from a specified table in an Aisello base by searching for a row where a chosen field matches a specified value.

Inputs

  • Base Name or ID (required) — Select the base containing the table. Choose from the list or specify an ID using an expression.
  • Table Name or ID (required) — Select the table to search in. Choose from the list or specify an ID using an expression.
  • Search Field Name or ID (required) — Select the field to match against when searching for the row. Choose from the list or specify an ID using an expression.
  • Search Value (required) — The value to match in the selected search field.

Output shape

a single record representing the matched row

Searches all rows in the specified table and returns the first row whose selected field's value matches the given search value. If no matching row is found, an error is thrown. The returned object contains the row's details including its values or cells.

Examples

Example 1: Retrieve a row by a specific email field value

Specify the base and table where the data exists, set the search field to the email field, and use the target email as the search value.

Links

Discussion