SeaTable icon

SeaTable

Consume the SeaTable API

Actions18

Row → Search

AI-generated

Overview

This node performs a search operation on rows within a specified SeaTable table. It allows users to search for rows based on various column types such as text, number, single-select, rate, and checkbox. The node supports different search conditions and options like case insensitivity, wildcard search, and result limits. It is useful for scenarios where you need to filter or find specific data entries in a SeaTable database, such as retrieving customer records, filtering sales data, or searching for specific entries in a project management table.

Use Case Examples

  1. Search for rows in a 'Contacts' table where the 'Email' column contains a specific domain, ignoring case sensitivity.
  2. Find all rows in a 'Sales' table where the 'Amount' column is greater than 1000.
  3. Retrieve rows from a 'Tasks' table where the 'Status' single-select column is set to 'Completed'.
  4. Search for rows in a 'Feedback' table where the 'Rating' column is equal to or greater than 4.

Properties

Name Meaning
Table Name The name of the SeaTable table to access. Users can select from a list or specify a name using an expression.
Column Name The column within the selected table to be searched. Only certain column types are supported for search. Users can select from a list or specify a name using an expression.
Column Type The type of the column being searched. This determines the kind of search and input required. Users can select from a list or specify an ID using an expression.
Search Term The text value to search for in text-based columns such as text, long-text, email, url, or formula columns. This property is required for these column types.
Case Insensitive Search A boolean option to specify whether the search should ignore case sensitivity (true) or distinguish between uppercase and lowercase characters (false).
Activate Wildcard Search A boolean option to specify whether the search should only return perfect matches (true) or find rows where the search value is part of a string (false).
Search Number The numeric value to search for in number-type columns. The value should be entered in decimal notation (xx.yy).
Condition The condition to compare the number or rate value in the search. Options include equal, greater or equal, greater than, less or equal, and less than.
Search Single-Select Option The option to search for in a single-select column. Users can select from a list or specify an ID using an expression.
Rate Value The rate value to search for in rate-type columns, constrained between 1 and 10.
Checkbox Status The checkbox status to search for in checkbox-type columns, either checked (true) or not checked (false).
Return All Whether to return all matching results or limit the number of results returned.
Limit The maximum number of results to return if 'Return All' is false. The limit can be set between 1 and 10000.
Simplify Whether to return a simplified version of the response instead of the raw data.
Return Column Names Whether to return the column keys (false) or the column names (true) in the response.

Output

JSON

  • rows - Array of rows matching the search criteria, each containing the row data with columns as keys or names depending on the 'Return Column Names' setting.
  • totalCount - The total number of rows found matching the search criteria.

Dependencies

  • SeaTable API access with appropriate credentials

Troubleshooting

  • Ensure the table name and column names are correctly specified and exist in the SeaTable base.
  • Verify that the column type matches the type of search input provided (e.g., text search for text columns, number search for number columns).
  • Check that the API credentials are valid and have sufficient permissions to read data from the specified table.
  • If no results are returned, confirm that the search term or condition matches existing data.
  • For large datasets, consider using the 'Return All' option carefully to avoid performance issues or timeouts.

Links

Discussion