Overview
This node integrates with NocoDB to manage rows in database tables. Specifically, the Row - Link operation allows you to create links between a row and other records via a link field in a specified table. This is useful when you want to establish relationships between data entries, such as linking a customer record to multiple orders or associating tasks with projects.
Common scenarios include:
- Linking a single row to multiple related records in another table.
- Managing many-to-many relationships by updating link fields programmatically.
- Automating relational data updates within workflows that use NocoDB as a backend.
Example: You have a "Projects" table and a "Users" table, and you want to link a project row to several user rows representing team members assigned to that project.
Properties
| Name | Meaning |
|---|---|
| Authentication | Choose the authentication method: "API Token" or "User Token". |
| API Version | Select the API version to use (currently only v0.200.0 onwards supported). |
| Workspace Name or ID | Select or specify the workspace where the base/project resides (only for API version 3). |
| Base Name or ID | Select or specify the base/project within the workspace (required for API version 3). |
| Project ID | Specify the project ID (string for older versions, options for newer versions). |
| Table Name or ID | Select or specify the table containing the row to link. |
| Link Field Name or ID | Select or specify the link field in the table used to create the relationship (required). |
| Record ID | The ID of the row in the table that you want to link from (required). |
| Linked Record IDs | JSON array of record IDs to link to the specified row (required). |
Output
The output is a JSON array where each element corresponds to the response from the NocoDB API after attempting to link records. Each item contains the updated row information reflecting the new links established.
If an error occurs during linking, the output may contain an error field describing the issue.
No binary data output is produced by this operation.
Dependencies
- Requires access to a NocoDB instance with appropriate permissions.
- Needs either an API token or user token for authentication.
- The node uses NocoDB REST API endpoints, specifically
/api/v2/tables/{table}/links/{linkFieldId}/records/{recordId}with POST method. - Proper configuration of workspace, base/project, and table identifiers is necessary depending on the API version.
Troubleshooting
- Error fetching link fields: Ensure the selected table has link-type columns; otherwise, no link fields will be available.
- Invalid record IDs: If the
recordIdor anylinkedRecordIdsdo not exist, the API will return errors. Verify IDs are correct. - Authentication failures: Check that the provided API token or user token is valid and has sufficient permissions.
- Incorrect API version or parameters: Make sure the API version matches your NocoDB instance and that all required parameters are set.
- JSON parsing errors: The
linkedRecordIdsmust be a valid JSON array. Invalid JSON will cause failures. - Network or API errors: These will be surfaced as node errors; enabling "Continue On Fail" can help process partial successes.