September 15, 2021
11 Minutes

How To Use A Cryptocurrency API With Parabola

By the end of this tutorial, you will have extracted data from an API without code. That knowledge will open up a whole new world of APIs to access.

Join 1,000+ readers and get my weekly newsletter. It's a minute read. I share work that I have shipped, work that has piqued my curiosity, and a haiku poem I have written.
You're in! Check your inbox :)
There's an issue. Try Again :)

Project Resources

Parabola

• Financial Modeling Prep

Google Sheets

Table Of Contents

1. Setting Up Your API

2. Filtering Your Data

3. Renaming Your Columns

4. Numerically Format Your Data

5. Exporting Your Data

6. Publishing Your Flow

1. Setting Up Your API

Sign up for an API key at FMP. And, sign up for an account on Parabola.

Log into Parabola and click ‘Add A New Flow’. Title your flow, ‘Bitcoin Tracker’.

Place the ‘Pull From An API’ function onto your canvas.

Open the function and set the ‘Request Type’ to ‘GET’. Then, confirm the ‘API Endpoint URL’ in the documentation (example below): enter it into Parabola.

Click, ‘Show Updated Results’. You should now have access to the API.

2. Filtering Your Data

Place the ‘Select Columns’ function onto your canvas.

Open the function and ‘Keep’ the following columns:

Click, ‘Show Updated Results’. 

3. Renaming Your Columns

Place the ‘Rename Columns’ function onto your canvas.

Open the function and rename the columns as follows:

Click, ‘Show Updated Results’. 

4. Numerically Format Your Data

Place the ‘Format Numbers’ function onto your canvas.

Open the function and format every column as follows:

Click, ‘Show Updated Results’.

5. Exporting Your Data

Place the ‘Send To Google Sheets’ function onto your canvas.

Open the function and authorise Parabola to post to your Google Sheet.

Click ‘File’, and ‘Create A New File’. Title the sheet, ‘Bitcoin Tracker’.

Under the export rule, select ‘Append’.

Click, ‘Show Updated Results’.

6. Publishing Your Flow

Click, ‘Publish’ to get your Parabola flow live.

Click, ‘Add Rule’ to the following scheduling rules for your flow:

Click, ‘Save Rule. Then, ‘Run Flow Now’.

Your flow will now go live. It will query the API, filter your data, numerically format your data, and export it to Google Sheets.

Join 1,000+ readers and get my weekly newsletter. It's a minute read. I share work that I have shipped, work that has piqued my curiosity, and a haiku poem I have written.
You're in! Check your inbox :)
There's an issue. Try again :)