n8N -> Baserow - Update connected table row

[collejack]

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

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.

[RicardoE105]

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.

[collejack]

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 ?

[collejack]

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

Generate an Array

Also @RicardoE105 just a small question. How can we remove the [Array:] keyword and just display the array. Im using the following to get the array from previous node. Expression [image] Result [image] Expected should be [999999999, 888888888]

[mibrahim547]

Thanks a lot man… i was struggling for the same issue for two hours.
it worked