Hi,
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 "https://api.airtable.com/v0/appXXX/MyTable?maxRecords=3&filterByFormula='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?
Thanks