0

I would like to get the items whose field A is IN (X,Y,Z...).

I've seen ways to do it with ORs (Rest API - $filter multiple values) but is there a simpler way?

Something like:

/_api/web/lists/getbytitle('Students')/items?$select=Title,ZIP&$filter=(ZIP IN [111,222,333,444])

Thanks!

Improve this question
1

1 Answer 1

Reset to default
1

You can use IN operator in CAML query with SharePoint REST API's GetItems endpoint.

Example of IN operator uses:

<Where>
  <In>
    <FieldRef Name="ID" />
    <Values>
       <Value Type="Number">1</Value>
       <Value Type="Number">2</Value>
       .
       .
       .
       <Value Type="Number">530</Value>
    </Values>
  </In>
</Where>

References:

  1. In element (Query)
  2. Make CAML query with in rest api call
  3. SharePoint REST API - CAML Query
Improve this answer
2
  • Thanks, is it possible to use it in the filters in the url of the REST query? If so, what's the syntax? I've googled around but no luck. Commented May 8, 2020 at 8:05
  • 1
    You need to write CAML query for filters check 2 reference link. it has the example given for the same Commented May 8, 2020 at 8:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.