Is it possible to GET data from external API to Airtable?

Hi @Manish_Patell - you could definitely code something that pulls data from Shiprocket and then passes this to Airtable. Using the Airtable API you can create, update etc:

If you don’t want to code this directly, you could use something like Zapier (using the Zapier webhooks component) to poll the Shiprocket API and create or update AT:

(Same idea, just less coding).

JB

Thanks @JonathanBowen, I didn’t knew it, leaning how to pull data from API.

Hi @JonathanBowen,

I have a similar question: If I have data in the form of a JSON, could I pass it to AirTable using a POST request?

You can create an Airtable automation to accept incoming POST webhooks.

However, Airtable’s webhooks have tons of limitations, so it is usually recommended to use Make’s custom webhooks instead.

Make’s webhooks accept both GET and POST webhooks, and they give you tons of power, customizability, and flexibility.

They also allow you to integrate with any app on the planet that has an API, so you would use Make’s webhooks in conjunction with Make’s Airtable integrations.

I demonstrate how to use Make’s webhooks on this Airtable podcast episode.

And if you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you can instantly trigger a Make automation from Airtable.

I also give live demonstrations of how to use Make in many of my Airtable podcast appearances. For example, in this video, I show how to work with Airtable arrays in Make.

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Yes, you can use a POST request to create a record in Airtable via the API. The JSON data you have will need to be mapped to the (JSON) format that Airtable is expecting. See the API documentation for your base for an example.

For anyone here from Google, you can use the free Data Fetcher extension to GET data from external APIs into Airtable with no-code.

It supports authorization, pagination, posting data in the API request body, and loads more features to make working with API data in Airtable really easy.