Create API Endpoint that returns a list of records based on an array of record IDs

[Kevin_Gutowski]

Hello I’m trying to query one of my tables and only return a list of records based on a list of record IDs. How would I write the filterByFomula query?

I tried to join a series of queries like

filterByFormula=(AND((_id%3D'{{record_id_1}}'),(_id%3D'{{record_id_2}}')))

However this didn’t work.

[kuovonne · Accepted solution]

Welcome to the Airtable community forums!

Try writing the formula in an Airtable formula field to test it out. You will need to use OR() instead of AND(). You will also need a different formula field that reveals the record ID of each record.

[Kevin_Gutowski]

OO of course. It worked when I switched it to OR. Thanks for the help!