Insert text into database

[hofer6]

Hi there,

I‘m dealing with chatGPT and storing text retrieved from chatGPT into a table.
The output of chatGPT is in CSV-format, like

Field1_1;field1_2
Field2_1;field2_2
Field3_1;field3_2

In addition to that I have a table with two columns, field1 and field2, both type text. How do I get the data in the response during a workflow stored in the database?

Many thanks!!!

Markus

[bubble.trouble]

“:split by…”?

[cmarchan]

Ask ChatGPT to give you the data in JSON format, build an endpoint that processes that JSON (make sure you set content-type structured JSON), call that endpoint internally and you can use those fields in further actions

How to integrate your Bubble app with OpenAI & ChatGPT to receive JSON Objects

[hofer6]

many thanks! by using the API-connector stuff I was now finally able to parse my JSON-string from chatGPT and store it in the database. However I do have an issue. When I initialize my API-connector and put the JSON-string into my body, it works fine.

The same JSON-string handed over to through a workflow to the corresponding backend-workflow causes an error:
Unexpected token \ in JSON at position 0

If I, for example, put the JSON-string into the textbox, copy&paste the text and re-initialize the API-call with this string, it works. Where is the difference??