SeaTable icon

SeaTable

Consume the SeaTable API

Row → Get

AI-generated

Overview

This node operation retrieves a specific row from a SeaTable table based on the provided table name and row ID. It is useful for scenarios where you need to access detailed data from a particular row within a SeaTable database, such as fetching user information, order details, or any record stored in a table.

Use Case Examples

  1. Fetching a customer record by its unique row ID from a 'Customers' table.
  2. Retrieving a specific order's details from an 'Orders' table using the row ID.

Properties

Name Meaning
Table Name The name of the SeaTable table to access. It can be selected from a list or specified using an expression.
Row ID The unique identifier of the row to retrieve from the specified table. It can be selected from a list or specified using an expression.
Simplify Whether to return a simplified version of the response instead of the raw data. Defaults to true.
Return Column Names Whether to return the column keys (false) or the column names (true). Defaults to true.

Output

JSON

  • rowData - The data of the retrieved row, either simplified or raw based on the 'Simplify' option.

Dependencies

  • Requires access to SeaTable API with appropriate credentials to fetch table and row data.

Troubleshooting

  • Ensure the 'Table Name' and 'Row ID' are correctly specified and exist in the SeaTable database to avoid errors.
  • If the node returns an error about authentication, verify that the API credentials are correctly configured.
  • If the response is empty or unexpected, check the 'Simplify' and 'Return Column Names' options to ensure they match the expected output format.

Discussion