Feb 03, 202401:42 PM - edited Feb 05, 202403:25 AM
Hey everyone, I just started learning Airtable scripts and I wanted to share my first project. This script uses the free Radar.com API to lookup a valid address from a partial address string, and saves the first matching result back to the table with individual fields for each component of the address.
Just add the Script extension and paste in this script, then fill out the settings pane with your API and field names.
Skips rows that already have a complete address
Caches results while looping over the table, then performs a bulk update to increase performance
Splits bulk update into batches of 50 to avoid issues on large dataset