Rest API - $filter multiple values

Question

Assuming there is a list of Students each with a zip-code, how can I get records for multiple (but not all) zip-codes.

When using $filter how do specify multiple values?

Here's what I have so far:

site.com/_api/web/Lists/getByTitle('Students')/items?$filter=ZipCode eq 12345

When I try:

site.com/_api/web/Lists/getByTitle('Students')/items?$filter=ZipCode eq '12345'&$filter=ZipCode eq '22222'

Or

site.com/_api/web/Lists/getByTitle('Students')/items?$filter=ZipCode eq '12345,22222'

These don't work, what is the right way of doing this?

Answer 1

As far as I know, you can not use &. You have to use and or or inside the filter.

So try using something like that:

/_api/web/lists/getbytitle('Students')/items?$select=Title,ZIP&$filter=((ZIP eq 12345) or (ZIP eq 22222))

I always use brackets because of the readability, but you can also use it without brackets.

items?$select=Title,ZIP&$filter=ZIP eq 12345 or ZIP eq 22222