How to map data from an Iterator to Airtable (only {{value}} available)

Hey everyone,

I’m struggling with mapping JSON data from an Iterator into Airtable.

Here’s my situation:

  • I have an Iterator module that outputs bundles like this:

    [
      {
        "Verstoß": "JA",
        "snippet": "We manage campaigns daily, optimize strategy, and adjust ad texts.",
        "timestamp": "00:49:11"
      }
    ]
    
    
  • When I connect the Airtable → Create record module, I only get a single variable available: {{value}}.

  • This value contains the entire JSON array, so I can’t directly map the individual fields (Verstoß, snippet, timestamp) into separate Airtable columns.

I’ve tried adding a JSON Parse module between the Iterator and Airtable, but it fails with errors like

BundleValidationError: Missing value of required parameter 'json'

because sometimes the input is empty.

:backhand_index_pointing_right: Question:
What’s the correct way to handle this scenario — when my Iterator outputs JSON objects (or arrays) and I want to store the individual keys as separate fields in Airtable?

Should I use another module (e.g. Text Parser, Set Variable, or Array Aggregator), or is there a specific mapping trick I’m missing?

Thanks in advance! :folded_hands:
Julian

Hey Julian,

{{value}} is the default item that an iterator outputs but you can still manually type in the ones that you need. {{147.Verstoß}} for example should give you the Verstoß variable.

I tried it in this run but it didnt work :confused:

In that first screenshot → when you hover over snippet and timestamp do they have values in them?

No values in them………………..

Can you try making them lowercase? Like they are in the initial post?

2 Likes