I want to import a JSON dataset. I know I can’t import JSON, but I know I can convert the JSON first to CSV, which is importable.
The problem with that is my dataset contains arrays inside the JSON object, eg.:
"variations": :
227,
329,
229,
190,
119,
123,
152,
155
]
In a JSON-to-CSV convertor, this comes out as multiple columns, variations/1
, variations/2
, variations/3
etc
That is not appropriate since, in Airtable, I want the “variations” field to be a Multi-select.
How can I accomplish this?