Linking NocoDB Records via API 🔗

This n8n workflow streamlines many-to-many record linking in NocoDB databases using API calls. It starts with a manual trigger, fetches necessary IDs (tableId, linkFieldId, recordId), retrieves existing linked records, appends the new link, and sends an efficient HTTP POST to the NocoDB API endpoint (/api/v2/tables/{tableId}/links/{linkFieldId}/records/{recordId}). This avoids manual UI updates or multiple requests, ensuring data integrity.

Benefits include significant time savings for database administrators and developers managing relational data. By consolidating operations into one request, it reduces API calls, minimizes errors from bulk updates, and supports scalable automations. Ideal for BI workflows where accurate linking is crucial for reporting and analytics.

Use cases: Linking customer orders to products in e-commerce setups, associating projects with team members in task management, or connecting sales leads to campaigns in CRM integrations. Perfect for NocoDB users in IT, development, or business intelligence needing robust data relationships without custom code.

Setup is straightforward: Copy IDs from NocoDB, configure the HTTP node with your instance URL and auth, and test once. Sticky notes provide API docs and examples for easy customization.