top of page
full-color_icon.png

Videos

Learn Airtable scripting #4: Using APIs in Airtable scripts with Giovanni Briggs

View Tool Page

Airtable

Database/Spreadsheet

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

Outline:
0:00 Intro
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 👈

Learn Airtable scripting #4: Using APIs in Airtable scripts with Giovanni Briggs

Related Videos

Add a Title

Add a Title

Add a Title

bottom of page