Issue parsing nested JSON list from OpenAI response in API Connector

[carlovsk.edits]

For this, you need to parse that JSON. Bubble can’t parse a string that is a JSON coming from OpenAI, so you need to work around this in other ways.

You can create an API workflow called “parse-json”, create a field called json, and simply have it return that in “return data from API” as shown in the screenshot below:

That way, you can configure this API call in the API Connector, where you send the content of the OpenAI LLM response in the “json” field, and Bubble’s response will be the parsed JSON. Then you save that body there in the API Connector’s initialize.

Just keep in mind that the structure of the JSON body must always be the same.

This topic can help you as well:

TIP: How to parse JSON with native Bubble (no ext plugins)

Hi all, I just wanted to pop in and share a quick tip. Understanding how parse to JSON in Bubble is something that comes up quite a bit, so I wanted to share a very simple, easy to follow method on how to do that – only using vanilla Bubble. I’ve created a Landing Page + Editor Links so you can look around and see how it works. Once you’ve opened the editor, you will be able to view debug mode to inspect the data sources. VIEW THE LANDING PAGE P…