Dear community,
I am new to airtable and would like your assistance on best practice on how to consume a json file and use linked relations within the airtables.
i have a json file with structure like this:
[ { "title":"first title", "publicationDate":"2021-02-02", "geo":[ { "country":"US", "lat":45, "lon":55 }, { "country":"UK", "lat":65, "lon":55 } ] }, { "title":"sec title", "publicationDate":"2021-02-02", "geo":[ { "country":"BR", "lat":4, "lon":5 }, { "country":"UK", "lat":65, "lon":55 } ] } ]
Ideally I would like to have two tables: Pub and Geo. When inserting the above resultset data should get loaded to pub with 2 entries and geo table with 3 entries.
is this possible using API? any example or directions on this would be appriciated.
or
do I need to create an attachment field (for json) first in airtable and then use the logic to split data into multiple table?
Thank you in advance for your help.