SeaTable icon

SeaTable

Consume the SeaTable API

Actions18

Row → Update

AI-generated

Overview

This node updates a specific row in a SeaTable table. It is useful for scenarios where you need to modify existing data in a SeaTable database, such as updating user information, changing status fields, or correcting data entries. For example, you can update a row by specifying the table name, the row ID, and the new values for the columns you want to change.

Use Case Examples

  1. Updating a user's contact information in a SeaTable table by specifying the row ID and new phone number.
  2. Changing the status of a project task in a SeaTable row by updating the status column.

Properties

Name Meaning
Table Name The name of the SeaTable table to access. You can select from a list or specify a name using an expression.
Row ID The ID of the row to update in the selected table. You can select from a list or specify an ID using an expression.
Data to Send Determines how the input data is sent to the row. You can either auto-map input data to columns if the input properties match the column names, or define each column value manually.
Inputs to Ignore When auto-mapping input data, specify any input properties to exclude from being sent to the row, separated by commas.
Columns to Send When defining column values manually, specify each column name and the value to set. Supports special formats for dates, durations, checkboxes, and multi-select fields.

Output

JSON

  • rowId - The ID of the updated row.
  • updatedFields - The fields and their new values that were updated in the row.

Dependencies

  • SeaTable API access with appropriate credentials

Troubleshooting

  • Ensure the specified table name exists and is accessible with the provided credentials.
  • Verify the row ID is correct and exists in the selected table.
  • When using auto-map, make sure input property names exactly match the column names in SeaTable.
  • If defining columns manually, ensure the column names are valid and the values are in the correct format (e.g., date formats, checkbox values).
  • Check for network or authentication errors if the update fails to execute.

Links

  • SeaTable API Documentation - Official API documentation for interacting with SeaTable, useful for understanding how to update rows programmatically.

Discussion