SeaTable icon

SeaTable

Consume the SeaTable API

Link → Add

AI-generated

Overview

This node operation adds a link between two rows in SeaTable. It is useful for creating relationships between data entries across different tables within SeaTable, such as linking a customer record to an order record or associating a project task with a team member.

Use Case Examples

  1. Link a row in a 'Projects' table to a row in a 'Team Members' table to assign tasks.
  2. Create a connection between a 'Products' table and an 'Orders' table to track which products are included in each order.

Properties

Name Meaning
Table Name (Source) The source table from which the link originates, specified by table name and ID.
Link Column The specific link column in the source table used to create the link, identified by column name, link ID, and the target table ID.
Row ID From the Source Table The row ID in the source table that will be linked.
Row ID From the Target The row ID in the target table to which the source row will be linked.

Output

JSON

  • linkedRowId - The ID of the newly created link between the source and target rows.

Dependencies

  • Requires SeaTable API access with appropriate permissions to modify table links.

Troubleshooting

  • Ensure that the table names and IDs are correctly specified in the format 'table_name:::table_id'.
  • Verify that the link column is correctly identified with 'column_name:::link_id:::other_table_id'.
  • Check that the row IDs provided exist in their respective tables.
  • Common errors may include invalid table or column identifiers, missing permissions, or incorrect row IDs. Verify credentials and input formats to resolve these issues.

Links

  • SeaTable API Documentation - Official API documentation for SeaTable, useful for understanding how to interact with tables and links programmatically.

Discussion