Getting the 1st record by searching field value

Topic Labels: API
1063 2
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I have studied the API docs and seen infos on how to retrieve a record, but my need is to get all the infos about a record with a special value in a field - say the 1st found “invoice” with “unpaid” in its status field, so I can act on it on an external system and then update the status to “reminded” for example.
How would that work ?
Thanks !

2 Replies 2
5 - Automation Enthusiast
5 - Automation Enthusiast

I feel this is the idea, but how can I simply state I am looking for records “WHERE suchfield =thatvalue” to mimic MySQL searches ?
Formula Field Reference - Overview | Airtable Support

In order to prepare the request I found this nice tool in case it helps others : Airtable API Encoder (

Look into the filterByFormula documentation for the REST API. You will need to construct a valid Airtable formula. I recommend testing the formula in an Airtable formula field.