microsoft graph API using filter on get sharepoint items

Question

i am trying to filter my Sharepoint Items results query with the Microsoft Graph API as explained here so i am trying this https://graph.microsoft.com/beta/sites/{site-id}/lists/{list-id}/items so i tried adding

?&filter=od eq 1, or copying from expand ?filter=fields(select%3Did) = 1, none works. please help

There is a feature request open here, please vote: https://feedbackportal.microsoft.com/feedback/idea/aa3cdd9a-b9f3-ec11-a81b-000d3a00c008 — mhbuur, Jun 24 '22 at 12:33

score 15 · Accepted Answer · answered Dec 01 '17 at 12:50

15

FOUND IT!

&filter=fields/id eq 1

&filter=fields/ContentType eq 'Apartment Page' -> NO DOUBLE QUOTES

&filter=startswith(fields/id,1)

answered Dec 01 '17 at 12:50

bresleveloper

5,940
3
33
47

2

Unfortunatly this doesn't seem to work anymore (testing in Graph Explorer) – mhbuur Nov 05 '19 at 13:59
This worked for me with setting header as Prefer : HonorNonIndexedQueriesWarningMayFailRandomly – koko Dec 08 '20 at 14:02

score 3 · Answer 2 · answered Aug 06 '20 at 02:35

3

@mhbuur

add request header Prefer: HonorNonIndexedQueriesWarningMayFailRandomly

answered Aug 06 '20 at 02:35

Mani

65
5

Thanks. This is not really a production ready solution though as it "MayFailRandomly" and it will certainly fail with large lists. – mhbuur Jun 27 '22 at 08:50

score 1 · Answer 3 · answered Oct 25 '18 at 15:31

1

You don't need to filter by id just do:

https://graph.microsoft.com/beta/sites/{site-id}/lists/{list-id}/items/{id}

answered Oct 25 '18 at 15:31

Baris Bikmaz

401
3
11

1

The id field is just for the example. The real challenge was an angular app with custom user input on text fields. – bresleveloper Oct 26 '18 at 13:16

microsoft graph API using filter on get sharepoint items

3 Answers3