Insert text into database

hofer6 · 2024-11-08T19:41:52.108Z

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 · 2024-11-08T20:28:08.432Z

“:split by…”?

Screenshot 2024-11-08 at 3.27.13 PM778×496 32 KB

cmarchan · 2024-11-08T21:49:25.325Z

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

CleanShot 2024-11-08 at 16.47.36@2x1236×648 39.4 KB

hofer6 · 2024-11-09T16:41:44.335Z

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.

Bildschirmfoto 2024-11-09 um 17.40.151646×788 40.9 KB

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??