Effortless NocoDB Record Linking via API
detail.loadingPreview
Automate complex record linking in NocoDB, including many-to-many relationships, by directly interacting with the NocoDB API. This workflow streamlines data connections, ensuring your database reflects interconnected information without manual effort.
About This Workflow
This n8n workflow provides a robust solution for programmatically linking records between different tables in NocoDB using its powerful API. Designed to handle both one-to-many and many-to-many relationships, it eliminates the need for manual record association within the NocoDB UI. By leveraging direct API calls, the workflow fetches necessary metadata and then posts the link, ensuring data integrity and consistency across your projects. It's an essential tool for anyone looking to build interconnected applications or automate data synchronization across NocoDB tables, making your database truly dynamic and responsive.
Key Features
- Automated Record Linking: Programmatically create links between NocoDB records across tables.
- API-Driven Integration: Directly interacts with the NocoDB REST API for precise control and robust performance.
- Supports Complex Relationships: Easily handles one-to-many and many-to-many linking scenarios.
- Dynamic Metadata Retrieval: Fetches target table metadata to correctly identify link field IDs.
- Configurable Parameters: Easily set NocoDB URL, target/source table IDs, and record IDs via a dedicated
Setnode.
How To Use
- NocoDB Credentials: Ensure you have an active NocoDB API token configured as a credential in n8n.
- Set Variables:
- Open the "Set Variables" node.
- Replace
<Your NocoDB URL, example: nocodb.myserver.com>with your actual NocoDB instance URL. - Update
<the ID of TARGET Table, see Video>with the ID of the table you want to link records to. - Specify
<the Record-ID of TARGET Table that you want to link to, see Video, example: 5>with the ID of the specific record in the target table. - Set
<the Record-ID of SOURCE Table that you want to link from, see Video, example: 23>with the ID of the specific record in the source table.
- Target Table Configuration: In the "Grab Target Table Row" node, update the
Tablefield with the ID of your target table. - Source Table Configuration: In the "Get Source Table Row" node, update the
Tablefield with the ID of your source table. - Execute Workflow: Once configured, click "Test workflow" or activate it to start linking your NocoDB records.
Apps Used
Workflow JSON
{
"id": "79231f9b-e24a-4c56-bcc5-09bf8afdad4c",
"name": "Effortless NocoDB Record Linking via API",
"nodes": 19,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 79231f9b-e24a...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.