Answered

$filter is not working in REST API call to get required items

(0) Share

Report

Posted on by Community Power Pla...

Hi Team,

we have a connector to pull the groups where the user is a member of

https://graph.microsoft.com/v1.0/users/userEmailId/MemberOf/microsoft.graph.group?$select=id,displayName,securityEnabled

it returns only the first 100 items only

here is the output

{
 "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#groups(id,displayName,securityEnabled)",
 "@odata.nextLink": "https://graph.microsoft.com/v1.0/users/a1140e29-d7b1-4e29-8e92-f47544b14046/MemberOf/microsoft.graph.group?$select=id%2cdisplayName%2csecurityEnabled&$skiptoken=RFAAAAFAAAAP_P1E7jbylBi5A25lAAAAAAAAAAAAAXMS4yLjg0MC4xMAABSoKoWXoRDAAAA",
 "value": [
 {
 "id": "a759-4dc9-8204-9eecd821b89e",
 "displayName": "G ESI USLegal",
 "securityEnabled": true
 }]
}

here is the filter query where we are trying

https://graph.microsoft.com/v1.0/users/useremail/MemberOf/microsoft.graph.group?$select=id,displayName,securityEnabled&$filter=startswith(displayName,'D')

here is the Graph Explorer output

any help here on how to filter using startwith

or how to loop next items using OdataNext

Your reply is really appreciated.

All responses (5)

Answers (2)

Verified answer

Community Power Pla... on at

Like (1)

Report

Re: $filter is not working in REST API call to get required items

@VictorIvanidze
Yes, it's working what's wrong ..? maybe you might have missed the Request Header
Make sure you have to add a request header. please check the below screenshot. Just now executed and shared the screenshot.

Let me know if you need any help
VictorIvanidze 12,463 on at

Like (0)

Report
Re: $filter is not working in REST API call to get required items

Hi @Anonymous,

please do me a favor an confirm the following request is working for you:
https://graph.microsoft.com/v1.0/me/MemberOf/microsoft.graph.group?$select=id,displayName,securityEnabled&$filter=startsWith(displayName,'D')
Community Power Pla... on at

Like (0)

Report

Re: $filter is not working in REST API call to get required items

@VictorIvanidze @lbendlin
it was a mistake from my end, because I missed the letter "s"
it should be "startswith" but tried it like "startwith" and hence I get the error.
I updated the query when I posted the post here, working fine.
VictorIvanidze 12,463 on at

Like (0)

Report

Re: $filter is not working in REST API call to get required items

The error message is quite informative - not supported. Don't use startsWith. Try to use eq.
Verified answer

lbendlin 7,941 Super User 2025 Season 1 on at

Like (1)

Report

Re: $filter is not working in REST API call to get required items

Case sensitive maybe? startsWith ?

Use the $filter query parameter to filter a collection of objects - Microsoft Graph | Microsoft Learn