DEV Community

Cover image for Easily make Airtable work like your website's database
Qasim Ali for NoCodeAPI

Posted on

Easily make Airtable work like your website's database

Airtable is a great app to automate your workflow. You can keep your payment records, habit tracks, todos, estimations of your next project — all at one place. It is today's Excel. But unlike Excel, you can make airtable act like your database.

Key Issue :— Airtable API is hard to integrate, because it has limits on calls and advance level documentation. For example 👇

By default, every GET request has 60 seconds of caching which means that the first API call will come from a third party application API and other API calls under the next 60 seconds from the caching server.

Confusing ? It is ! Below is a work around to fetching airtable data to your website without getting into unnecessary details.

Step 1 : Get your Airtable API Key

image

  • Click here 👉 airtable.com/account to go to airtable account's page.
  • Click on Generate API Key under the API heading.
  • Click on password input field to pick your API Key.

Step 2 : Get your Airtable Base ID

image

  • Click here 👉 airtable/api · to go to airtable's API page.
  • Click on your airtable base (Base is your file name).
  • Copy your Base ID — It starts with letters app

Step 3 : Add this data to NoCodeAPI

image

  • Sign In to your nocodeapi dashboard.
  • Go to Marketplace
  • Activate your Airtable app
  • Click on “Make Airtable API”
  • Fill in API Key (from Step 1) and Base Id (from Step 2)
  • Press the “Create” button

Step 4 : Test if it is working Ok

image

  • Click on “Use this API” button just above your generated Api
  • Select “Get” on the overlay just appeared
  • Select “Click & Test API”
  • Enter your "tableName" — this is the sheet name of your airtable base

image

  • Press “Execute” to test it

You should get a 200 response with all rows in your airtable listed in JSON format.

You are done 😀

Through your airtable integration you can make GET, POST, PUT and DELETE requests to manage your database.

If finding something confusing, watch this video tutorial.

I hope you enjoyed this blog. You can contact us on telegram at nocodeapi.

Thank you. ✌️


Advanced Readers

Paid users can customise caching time. Pass cacheTime (in seconds) as query param with your api end point.

https://v1.nocodeapi.com/gitdansih/airtable/ePcgqeUWUNWgmPmN?cacheTime=900

Now your endpoint will be cached for 900 seconds(15 minutes).

Discussion (0)