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
- 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
- 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
- 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
- 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
- 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).
Top comments (0)