n8N -> Baserow - Update connected table row

Hi. Can anyone help me? I am stuck updating a row between two tables (Contacts <-> Companies) on Baserow.

CleanShot 2021-10-11 at 19.18.16

I’m trying to link two tables together via the Companies column, but I keep getting an error message telling me it’s expecting an integer.

The Baserow API documentation is clear though, it expects an array with the row ID of the other table.

Accepts an array containing the identifiers of the related rows from table Companies. All identifiers must be provided every time the relations are updated. If an empty array is provided all relations will be deleted.

You have to set the ID with an expression. For example: {{[1]}} assuming that 1 is the ID that you want to reference. Make sure you add it as an expression and not as a string in the field. Let me know if that helps.

Thanks a lot, it works
@RicardoE105, I have a last question, if instead of “1”, I have a dynamic value retrieved from another Node, it does not work anymore. Do you have a solution ?

I think I found the solution with the answer of @Asit_Joshi

2 Likes