Learn Airtable scripting #4: Using APIs in Airtable scripts with Giovanni Briggs
Welcome to Learn Airtable scripting a 4 part series where you'll learn the basics of writing scripting in Airtable. In
Welcome to Learn Airtable scripting a 4 part series where you'll learn the basics of writing scripting in Airtable.
In part 4, Gio continues teaching us (and me!) how to get information into our Airtable base from external services also known as APIs. We cover the basics of what is an API, how to call APIs from Airtable and common issues you may run into.
Template bases with final scripts: https://airtable.com/shrGTk09k8lOtIuND
2:16 Today's objective: calling APIs in scripts
3:16 What is an API?
10:16 Base overview: getting the weather for an upcoming event
13:06 Weather API overview
23:16 Writing a simple API call in Airtable scripting
27:04 Common Airtable scripting error: CORS
28:36 Writing a suscessful API call
33:31 Using automations to run the OpenWeatherAPI due to CORS
40:16 Outlining the script
41:51 Step 1: Read the record that triggered the automation
43:36 Step 2: Call the WeatherOpenAPI API for the right city
49:26 Step 3: Output the weather from the script
52:59 Step 4: Update the record with the expected temperature with automations
54:00 Testing out the whole flow!
54:41 Improving the script
Links to the whole series:
Part 1: https://www.youtube.com/watch?v=uuUojfQimzQ
Part 2: https://www.youtube.com/watch?v=zHQjljEov30
Part 3: https://www.youtube.com/watch?v=wo7wKxLNYoU
Part 4: https://www.youtube.com/watch?v=qhGb42NWc-E
--------- About Automate All the Things ---------
Automate All the Things is a weekly show hosted by Aron Korenblit on twitch where you'll learn how to work smarter not harder by using no-code tools.
→ Add the Automate all the things to your calendar: http://bit.ly/aatt-calendar
→ Get a weekly Airtable tip: https://read.aatt.io
→ Get the Essential Guide to Airtable: https://www.aatt.io
→ I tweet at https://twitter.com/aronkor
→ Suggestion for the next stream? 👉 https://airtable.com/shrGTbGQ3oe6Zqu3K 👈