Jun 29, 2021 10:29 PM
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?
Jun 30, 2021 04:27 AM
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.
But you could probably also write your own custom JavaScripts to handle this as well.
There might be other ways of doing this, too.
Jul 05, 2021 04:22 PM
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.