I’m playing around with the new API query. This looks very promising and I already managed to retrieve records from my Airtable base.
In order to filter the results based on the value in a certain field, Airtable has the filterByFormula parameter. The value should look like {Category}="Book" and has to be URL encoded (so the eventual URL looks like https://api.airtable.com/v0/baseid/tablename?filterByFormula=%7BCategory%7D%3D%22Book%22).
Thing is, when I pass that parameter, I get Request: Error (HTTP 422: Unprocessable Entity), no matter how I format the value (So %7BCategory%7D%3D%22Book%22 or {Category}="Book" )
If I attach the encoded parameter to the base URL and don’t pass it as a separate parameter, it works just fine and I do get the filtered results.