Hello community,
I have a workflow in n8n that updates records in a NocoDB table, but I’m having difficulties specifically with fields that have many-to-one relationships.
My scenario
I have a table in NocoDB that contains some normal fields and two fields with many-to-one relationships to other tables.
I use a NocoDB node in n8n to update existing records in this table.
I’m not clear on how to format the data for the many-to-one relationships when sending them from n8n.
I’ve tried passing the arrays that the query gives me plus adding the new data, but although the update doesn’t give me any error, it also doesn’t add the new data to the arrays.
The modified data in the other common fields (that don’t have relationships) are updated correctly.
Specific questions
- What is the correct format for sending many-to-one relationship data from n8n to NocoDB?
- Is there any special configuration needed in the NocoDB node to handle these relationships?
- Has anyone managed to update fields with many-to-one relationships in this configuration?
I would greatly appreciate any guidance, documentation, or examples you can share.
Thank you in advance for your help!