Create Record With Query Parameters

Kelvin_Ramirez · ‎Jun 01, 2020

Hello!

I have a program that can make API calls via HTTP Request but you can only input URL’s.

Is it possible with the Airtable API to create records using just a URL with query parameters?

Everything I’m finding says to use curl but that’s not possible with the software I’m using.

If not is there a service that my software can send a URL with query parameters to and then it takes it and executes the proper curl to Airtable? Maybe Postman?

Thank you.

ScottWorld · ‎Jun 01, 2020

Sounds like @openside has an exciting solution coming very soon! Can’t wait to see it! :slightly_smiling_face:

One other thing you might want to explore is that Integromat accepts webhooks, which means that it can be on the receiving end of a URL.

So you can send your URL to Integromat, and then you can have Integromat parse the data from the URL and create a new record in Airtable for you, using its Airtable integration.

See Solution in Thread

Bill_French · ‎Jun 01, 2020

Welcome to the community @Kelvin_Ramirez!

I generally build this if I need to in Google Apps Script, but your question is fundamentally related to the concept of inbound webhooks. Ideally, Airtable would support both out and inbound hooks that create HTTP posts (or GETs) and listen for them as well.

@openside, you folks have such a service?

openside · ‎Jun 01, 2020

interesting use case… we have a product inching close to finish line that is intended for overcoming CORS issue, but it essentially would allow you to set up a GET url that then performs a POST/PUT/PATCH to an external url (i.e. airtable api). So you could actually accomplish this scenario using that service. DM me if you want to get on waiting list for when its ready.

ScottWorld · ‎Jun 01, 2020

Sounds like @openside has an exciting solution coming very soon! Can’t wait to see it! :slightly_smiling_face:

One other thing you might want to explore is that Integromat accepts webhooks, which means that it can be on the receiving end of a URL.

So you can send your URL to Integromat, and then you can have Integromat parse the data from the URL and create a new record in Airtable for you, using its Airtable integration.

Ashwin_P · ‎Jun 01, 2020

Would something like this work for you?

It connects to an API and populates your table.

Maybe you can use the code there for your requirement.