Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

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

Topic Labels: Formulas
6307 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Manish_Patell
5 - Automation Enthusiast
5 - Automation Enthusiast

how can we get data from API in Airtable? below is the sample API

curl -X GET "https://apiv2.shiprocket.in/v1/external/courier/track/shipment/1559017361980" -H "accept: application/json"

is it possible ?

5 Replies 5

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:

07

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:

Screenshot 2019-06-04 at 08.09.46.png

(Same idea, just less coding).

JB

Manish_Patell
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

Yes, you can use an Airtable webhook or you can use an external automation tool like Make.com.

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.