paste text into Table Editor create view - jsonB not parsing correctly

[MildTomato]

Bug report

• [x] I confirm this is a bug with Supabase, not with my own application.
• [x] I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

JSON is not being parsed correctly in the paste text side panel when creating a new table via the Studio UI.

To Reproduce

Steps to reproduce the behavior, please provide code snippets or a repository:

1. Go to supabase.com/dashboard
2. New table, use these columns
   • reference:string, status:string, cargo:jsonb
3. "Import data via spreadsheet"

4. paste the following

   reference,status,cargo
   abc123,offline,[ { "age": 23, "name": "Jane" }, { "age": 25, "name": "John" } ]

   error is : Too many fields: expected 3 fields but parsed 6

Expected behavior

A clear and concise description of what you expected to happen.

Screenshots

If applicable, add screenshots to help explain your problem.

System information

• OS: [e.g. macOS, Windows]
• Browser (if applies) [e.g. chrome, safari]
• Version of supabase-js: [e.g. 6.0.2]
• Version of Node.js: [e.g. 10.10.0]

Additional context

Add any other context about the problem here.

[ivasilov]

Reported an issue to papaparse, the library we use for parsing.

[KevinBrolly]

@ivasilov Looks like the papaparse issue is closed as Wontfix, so we would need to either use a different library or patch ourselves to fix this issue.