Airtable: Update a record - RuntimeError [422] Cannot parse value for field xxx

How To
,
1

Hi Makers, I’m trying to update an Airtable record, specifically a multi-select field, by adding a new value “Pause” to the existing values.

{{split(2.Messages + ",Pause"; ",")}}

image

For some reason this fails with an “RuntimeError [422] Cannot parse value for field Messages”. I’m confused as I use a similar setup in other scenario. Am I missing something here?

Thanks!

Here’s the input bundle:

[
    {
        "id": "recXXX",
        "base": "appXXX",
        "table": "tblXXX",
        "record": {
            "fldXXX": [
                [
                    "Ready",
                    "Pause"
                ]
            ]
        },
        "typecast": true,
        "useColumnId": false
    }
]
2

Hmm, perhaps you can use the iterator-aggregator combo trick to map an array into the “Messages” field (not Value 1 field).

Every result (item/record) from a search/match module will output a bundle. To “combine” them into a single structure, you’ll need to use an aggregator of some sort.

Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and has applies to many use-cases.

There are other types of aggregator modules, click the below links to find out more:

Read This

The Array Aggregator module allows you to build a complex array of collections for a later module’s field to map multiple items (collections) to it.

Here is an example of using the “Target structure type” of an Array Aggregator module:

Screenshot_2024-01-17_100113
Screenshot_2024-01-17_1001131247×438 86.6 KB

As you can see, the “Map” toggle on fields are used when you have an array. You can easily build an array variable to map to a field, by using an Array Aggregator module and select the “Target Structure Type” as the future field you want to map the array into.

samliew – request private consultation

Join the Make Fans Discord server to chat with other makers!

3 Likes