Turn OpenAI's API Responses From Text to JSON Easily With Function Calling In Bubble

In this video we will turn ‪@OpenAI‬'s Chat Completions responses into structured JSON arrays (lists) using their Function Calling feature. Everything will be built in ‪@BubbleIO‬ with no code and no plugins (other than the API Connector). 🙌
Included:
How to structure the OpenAI Chat Completions API call with a JSON Schema.
How to turn the initial response as a text string of the JSON format into usable JSON in Bubble using Bubble's Backend Workflows
How to use the structured data in your Bubble app.
Resources: blankslatelabs...

[@roberthayes4312]

This is the cleanest solution I've seen to converting strings into usable JSON. Appreciate the detailed walkthrough here!

[@davewliu]

Your tutorials are the clearest and best in the bubble community. Feel like these videos should have 20x views!

[@BlankSlateLabs]

So appreciated!

[@ajmound790]

So damn helpful. Every last one of your videos goes through something I need right now and can't find documented anywhere else. Wanted to just say thank you!

[@PocketRiches]

Make more bubble videos, please. Yours are the best. 😁

[@xuyaoren]

Exactly what I need, thanks for your effort.

[@BlankSlateLabs]

Glad it helped!

[@malekaimischke2444]

thank you for this video!

[@BlankSlateLabs]

No problem!

[@watchparth]

Super cool!!

[@tima3829]

Hi, which browser do you use? :) It looks cool

[@BlankSlateLabs]

Arc Browser!

[@ninovizi]

Hey, what tool are you using for those effects as your mouse moves? There's so many startups for that already - wondering which you picked!

[@BlankSlateLabs]

I am team screen.studio :)

[@Fannyvieira1]

thank you so much

[@procrastinateXrok]

Next video please continue and put them into list

[@BlankSlateLabs]

nice, good suggestion. lemme put something together. (also can update with json mode vs. function calling)

[@SashaShumylo]

How to save it in DB as a separate entities?

[@BlankSlateLabs]

Two steps: 1. Create a backend workflow that takes in the parameters. So in this example: - keyword (data type text) - sentiment (data type text or an option set) within that workflow, you would create a new thing, and set the values based on the parameters. 2. Schedule API workflow on a list. Select the list from the response and configure to pass the parameter values for each item in the list.

[@SashaShumylo]

@@BlankSlateLabs thank's, the biggest problem was how to select the proper data type.

[@abbeyjackson4362]

Thank you for this tutorial! With it I was able to get data returned in a consistent format (finally!) but I am really struggling to use the json that is returned and wonder if you might be able to help me figure it out. I have the following json which I was able to get returned to me from OpenAI using function calling. I need to display the raw json array of products for each category in a different display group. In otherwords I am trying to extract the json string under products for each category and displaying the extracted json in a display group. I both need to display the raw products json for each category separately as well as USE this raw products array in a future API call. I absolutely can not figure out how to do this. I have been trying for several days. I have tried a few different plugins to no avail. Does anyone know how to do this? { "lists": [ { "category": "ENUMValue1", "products": [ { "name": "name1", "rating": 95, "url": "url1" }, { "name": "name2", "rating": 95, "url": "url2" }, ] }, { "category": "ENUMValue2", "products": [ { "name": "name1", "rating": 95, "url": "url1" }, { "name": "name2", "rating": 95, "url": "url2" }, ] }, { "category": "ENUMValue3", "products": [ { "name": "name1", "rating": 95, "url": "url1" }, { "name": "name2", "rating": 95, "url": "url2" }, ] } ] }

[@BlankSlateLabs]

Hiiii so sorry for the delay. you probably already solved this, but if not, feel free to email me at hello [at] blankslate-labs.com and happy to chat through options.