Get the value of a lookup field

[PMoby]

Hi,
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 !

[PMoby]

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 (codepen.io)

[kuovonne]

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.