Search…
⌃K
📈

Using AirTable w/ CRANQ

We follow Toby as he gathers crypto exchange rate data from Yahoo Finance, manipulates it into a new data format, and inserts, and updates it in AirTable using a loop

Project Overview

This project is going to help you master some fundamental skills in CRANQ! We're going to pull data from the Yahoo Finance API, and insert it into AirTable, all with low-code. Then we're going to map that data, and continuously update it, so we could make a trading alert, for example. Along the way, we'll also work on using variables and buffers.
In this first video in the series, we'll look at a completed version of the programme we will build.
Introduction and overview

Getting an Exchange Rate and Inserting it into Airtable

We will use the Yahoo Finance API to get prices, then we will convert them into records, and subsequently, AirTable records. After we've authenticated the Airtable API, we can insert our records into an AirTable. As preparation for this course, you should open an AirTable account.
Getting Rates and Inserting Them
Since we made the video, we renamed the 'records' input port on the the Bulk Records Inserter to the 'AT records' port for clarity

Updating the Exchange Rates and Creating a Loop

Now we have the records inserted into AirTable, we can retrieve them, separate out their IDs, and update them with a loop. At the end, we'll clean everything up and make sure that we have a single point where we input pair names and authentication details. I hope you enjoyed this course, what will you do with your new low-code skills?