SeaTable icon

SeaTable

Consume the SeaTable API

Actions18

Row → Create or Update

AI-generated

Overview

This node interacts with SeaTable to create or update rows in a specified table. It is useful for automating data synchronization between external systems and SeaTable, ensuring that rows are either added or updated based on matching column values. For example, it can be used to update customer records or inventory data automatically when new information is received.

Use Case Examples

  1. Automatically update a SeaTable row when a new order is received in an e-commerce system.
  2. Create a new row in SeaTable for each new lead captured from a marketing form.

Properties

Name Meaning
Table Name The name of the SeaTable table to access, selected from a list or specified via expression.
Columns to Match On The column(s) used to find existing rows to update. All selected columns must match for a row to be updated.
Data to Send Determines whether to auto-map input data to columns or define values for each column manually.
Inputs to Ignore List of input properties to exclude from sending when auto-mapping input data, separated by commas.
Columns to Send Specify columns and their values to send when defining data manually.
Save to "Big Data" backend (if new row is created) Whether to write to the Big Data backend when creating a new row. Requires Big Data backend activation in the base.
Apply Column Default Values Whether to use column default values to populate new rows during creation (only for normal backend).

Output

JSON

  • rowId - The ID of the created or updated row.
  • tableName - The name of the table where the row was created or updated.
  • operation - The operation performed, either create or update.
  • matchedColumns - The columns used to match existing rows for update.
  • dataSent - The data sent to the table for the row creation or update.

Dependencies

  • Requires SeaTable API access with appropriate credentials.

Troubleshooting

  • Ensure the table name is correct and accessible with the provided credentials.
  • Verify that the columns specified in 'Columns to Match On' exist and are searchable in the SeaTable table.
  • When using auto-mapping, ensure input data fields exactly match the column names in SeaTable or use an 'Edit Fields' node to rename them.
  • If writing to the Big Data backend, confirm that the Big Data backend is activated in the SeaTable base.

Links

Discussion