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