How can I query Airtable using an API

[Prahalad_M]

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.

[kuovonne]

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.

[Andrea_Marchisi]

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

[Andrea_Marchisi]

I solved my problem: I read more filterByFormula.

Very good.
Andrea