Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Jun 29, 2021
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, 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?
Jun 30, 2021
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.
Jul 05, 2021
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.