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
Mar 14, 2021
Hi there. We are looking to import order data into Airtable with something similar to the following CSV functionality except through the API:
We would like to trigger automations only when there are a) new rows or if b) certain fields for an existing row are updated (eg. order cancelled field: null → ‘cancelled’).
Is there anyway to accomplish something like this through the api? Any other suggestions are greatly welcomed :).
Mar 15, 2021
Hi @ir_cdmed - I wrote a small python script a while back that imports data using the API:
You could follow this pattern with pretty much any programming language that can parse a csv file and call an API.
I haven’t tried this out, but I assume new records imported via the API could then have automations triggered against them.