Mapping values / array to a lookup field in Airtbale

Questions & Answers
1

Hello,

I am struggeling with the following case.
I have two airtable tables that are linked via a lookup field that allows linking to multiple records.
I am fetching data from an external database and I want to update the linked field with the “map” option.
Somehow I can´t manage to send the data as an array. The airtable component always understands it as a single string and thus creates a new record.

I am passing in the record IDs for the table to link to e.g. like

["recqX0i1KtxVGSMjz","recdohqdJtBlHdI5n","recdohqdJtBlHdI5n"]

but it is always send as one string
image

What am I doing wrong?

Thanks for your help,
Ingo

2

I was not able to figure out what I was doing wrong.
I ended up building the array with the text aggregtor and just sending a patch request via the Airtable API.

curl -X PATCH "https://api.airtable.com/v0/{baseId}/{tableIdOrName}/{recordId}" \
-H "Authorization: Bearer YOUR_TOKEN" \
-H "Content-Type: application/json" \
--data '{
    "fields": {
      "FieldToUpdate": ["recqX0i1KtxVGSMjz","recdohqdJtBlHdI5n","recdohqdJtBlHdI5n"]
    },
"typecast": true
  }'

I would still be interested in a solution that don´t require this additional API call.