CSV into JSON format using OpenAI or Gemini

Need help APIs
1

I have a scenario where my user needs to upload a CSV file, but the field in csv sometimes not be as aspected some time a field description has a line bread or double comma.

thus extracting the data is really hard, is there a way I handle unstructured csv. or any AI model to use, like OPEN AI, Gemini AI?

I used Open AI assistant, but the output is random not from the file I sent. and with the response taking very long, bubble API connects can’t wait that long.

Any Advise form community

2

You may want to use the open AI API and initialize your prompt using this.
However make sure that in the message that you list the properties you want them to be parsed e,g name | description | phone number | website

3

This topic was automatically closed after 70 days. New replies are no longer allowed.