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

CSV Style Import

Topic Labels: API
871 1
Showing results for 
Search instead for 
Did you mean: 

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 :).


1 Reply 1

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.