Help

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

Solved
Jump to Solution
1421 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Kevin_Gutowski
6 - Interface Innovator
6 - Interface Innovator

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
kuovonne
18 - Pluto
18 - Pluto

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
kuovonne
18 - Pluto
18 - Pluto

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!