Skip to main content

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 !

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)

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.



Reply


Terms & Conditions