NocoDB: How to write fields of linked columns via NocoDB Node

Questions
,
1

Describe the problem/error/question

Maybe this is more of a NocoDB problem, but I’ll try with your input anyway.
I have a table with four columns. Two “string” columns and two columns with links (issue_id, clip_id). I can’t get the link columns to be populated by name. I assume that the values are “nested” and therefore cannot be easily described.
The structure is currently very complex, which makes posting a little more difficult. But the question is actually quite simple, even without knowing the workflow. How can I (in the end) describe my link columns (insert an ID) via the API or the NocoDB node? I just can’t figure it out and can’t find any documentation. There is no error at all.
In this examle I tried to nest it, but that doesn’t work.

[
{
"clip_id": 
"{ "Id": 5 }",
"issue_id": 
[
{
"Id": 
9
}
],
"timecode": 
"15:37:01:17",
"comment": 
"pixel",
"Id": 
10
},

Thank you very much for your help.

What is the error message (if any)?

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

  • **n8n version:1.99.1
  • **Database (default: SQLite):?
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • **Running n8n via (Docker, npm, n8n cloud, desktop app):NocoDB LXC Container (Helper Script)
  • **Operating system:Debian GNU/Linux - Version: 12
2

When you GET a table with link fields, the API returns only the count of linked records, not the nested objects because Links fields are optimized to show counts by default.

To grab actual linked records, you need to use the nested link endpoint:
GET /api/v2/tables/{tableId}/links/{linkFieldId}/records/{recordId}?fields=col1,col2

This returns the specified fields (fields=col1,col2) from the related table for a single record

To discover the correct linkFieldId, use the meta API:

GET /api/v2/meta/tables/{tableId}
This response details all columns, including linkFieldId values you can reference

3

Thank you! But I switched to Postgres, that seem much easier for now.

1 Like