DEV Community

loading...
Cover image for Easily make Airtable work like your website's database
NoCodeAPI

Easily make Airtable work like your website's database

qasim2020 profile image Qasim Ali ・2 min read

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)

pic
Editor guide