Skip to main content

How can I query Airtable using an API

  • May 10, 2020
  • 3 replies
  • 111 views

Here is an example table that I have in airtable.

For a month parameter of 6, I am trying to obtain the corresponding Median value i.e. 65.7, can someone please guide me on how I can I obtain this i.e. just by providing Month parameter obtain the Median value using the Airtable API.

Many thanks.

3 replies

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • 6009 replies
  • May 10, 2020

How much of the api integration do you have written already and how are you connecting to the api?

The documentation at https://api.airtable.com explains how to list records. To get a specific record based on a field value, you can use a filterByFormula parameter as part of your request.


  • New Participant
  • 2 replies
  • May 20, 2020

How much of the api integration do you have written already and how are you connecting to the api?

The documentation at https://api.airtable.com explains how to list records. To get a specific record based on a field value, you can use a filterByFormula parameter as part of your request.


Hello @kuovonne,
I’m trying to get a specific record filtering by a specific field like email, maybe the right method is “retrieve” but I have not the IDs.
How I can do that?

Thanks
Andrea


  • New Participant
  • 2 replies
  • May 21, 2020

I solved my problem: I read more filterByFormula.

Very good.
Andrea