Search for data using filterByFormula

Topic Labels: API
5633 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


I have a table with a column called Last Name. I want to search for all rows which the last name, for example, contains riva. Then it would have to return rows for the last names Trivax and Trivedi for example.

I use the following cURL command:

curl "'SEARCH('riva', {Last Name})'" -H "Authorization: Bearer MyAPIKey"

But it doesn’t work. I also have tried replacing { and } and space with proper url encoding, but still no luck. Any suggestion how the cURL command for this should be written?


1 Reply 1
8 - Airtable Astronomer
8 - Airtable Astronomer

The field type of “last name” should be of type “single line text” or “Long text”.
Have you tried using the formula directly in your base, by creating a test field?
Does it work fine then, or are you getting an error?

Also the “{” and “}” symbol also has to be URL encoded.
So it would look something like