There are only 2 ways to loop through JSON data and create a new record in Airtable for each record in your JSON data:
Use an external automation tool that offers webhooks, like Make.com. Send your data to a webhook there, and Make will automatically loop through all the JSON records on your behalf so you can create individual records in Airtable. (Make might also natively support whatever app is providing you with that JSON data.)
it’s a tricky task for first time, but last weeks I had todo a lot of table ‘rotations’, so it’s not so much code needed
put each value in separate variable, try to not add spaces and extra chars, because then array will be converted to string.
I did for 4 properties, for example, you may add all or choose any you want and even no need to change code.
You can use output variables to create records at next step. I mean, 3 next create record steps ))