Help

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

Topic Labels: API
Solved
Jump to Solution
120 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

1 Solution

Accepted Solutions

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.

See Solution in Thread

2 Replies 2

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.

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