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.:
In a JSON-to-CSV convertor, this comes out as multiple columns,
That is not appropriate since, in Airtable, I want the “variations” field to be a Multi-select.
How can I accomplish this?
I use Integromat for this, which is a low-code automation & integration platform with full support for Airtable. Integromat is setup to process JSON by default.
There might be other ways of doing this, too.
That’s the method that I would recommend, @Robert_Andrews. The Scripting app allows you to ask the user for a file, so you could directly load the JSON file, parse it, and update your base accordingly.
This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.