JSON & Iterator mapping not working

[Kevin_Hayes]

Hi all,

I’m working on a scenario where I parse a JSON string into structured data, and then pass that into an Iterator. That part seems to be working correctly — I can see that the Iterator is emitting the expected bundles (each with title and url fields).

The problem is: when I try to use the Google Sheets > Update Row module after the Iterator, I don’t see the option to map the Iterator outputs (title, url) into the row fields. I’ve tried checking both the Iterator and JSON module in the mapping panel, but the fields just don’t appear. I want to map the title and and URL from each operation into a google sheet.

Am I missing a step here? Do I need to run the scenario once before the Google Sheets module can access the Iterator output?

Any guidance would be appreciated — thanks!

JSON → Iterator → Google Sheet (update row)

JSON

Iterator

Google Sheet (ignore the iterator values in F,G,H).

[Kevin_Hayes]

Solved my own problem! ¯_(ツ)_/¯

Here’s what the problem was:

I had this as the JSON output:

[
{ “title”: “Insights”, “url”: “…” },
{ “title”: “Events”, “url”: “…” },
{ “title”: “Webcasts”, “url”: “…” }
]

I needed this to be the JSON output

{
“title1”: “…”,
“url1”: “…”,
“title2”: “…”,
“url2”: “…”,
“title3”: “…”,
“url3”: “…”
}

[Stoyan_Vatov]

Hey Kevin,

1st - you dont need the iterator, its already separate bundles.
2nd - you dont need the parse JSON, you can configure the openAI module to parse it directly. Its in the advanced settings near the bottom - you can tell it to send the response in a JSON format and then parse the JSON.

[Prem_Patel]

@Kevin_Hayes Use this as a reference to parse response from openAI output

Best,
@Prem_Patel

[Kevin_Hayes]

Thanks! You are right!