Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Filter data by id's results 'unknown field names: id'

Topic Labels: API
4832 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Tangent_Lin
4 - Data Explorer
4 - Data Explorer

Hi, I try to filter airtable using the by the record’s id, for example

filterByFormula=OR( {id} = ‘rec1’, {id} = ‘rec2’, … )

and I got the error “unknown field names: id”. That also results in errors even after I remove the brace brackets.

Tangent

3 Replies 3
Andrew_Johnson1
8 - Airtable Astronomer
8 - Airtable Astronomer

You can only filter by fields that are present in the “fields” part of JSON object returned by the API.

Unless you have explicitly declared the field “id” in your base you can not filter by it.

openside
10 - Mercury
10 - Mercury

So what you want to do is create a new formula field that uses RECORD_ID() in order to display the id. Then you can reference that field in your filter

Really? What is the syntax? this does not work for me: fldnwAXj3iM53qu4y or this {fldnwAXj3iM53qu4y}.