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.
do I need to create an attachment field (for json) first in airtable and then use the logic to split data into multiple table?
Hi @Harpal_Shergill, this is definitely doable using the API. You do not need to create an attachment field first. You can look in this thread for some guidance on how to create a linked record. For you reference, the REST api is documented here.
Alternatively, if you want to avoid writing code altogether, you can do what I do when I am parsing JSON files into Airtable for my clients, which is to use Integromat’s JSON parsing tools:
Integromat is a no-code/low-code automation platform that has 100% native support for Airtable’s API:
(Note that I am a professional Airtable consultant and a Registered Integromat Partner, and the Integromat links contain my personal referral code.)