How to use multiple filter operations in beta Graph API?

Question

I am trying to run the following API:&nbsp; https://graph.microsoft.com/beta/users?$count=true&amp;$filter=signInActivity/lastSignInDateTime le 2022-09-01T00:00:00Z and endsWith(mail,'@alumni.xxx.xxx')&nbsp;and I get the following response:&nbsp;&nbsp; {
     "error": {
         "code": "BadRequest",
         "message": "Filter not supported.",
         "innerError": {
             "date": "2022-12-22T19:21:39",
             "request-id": "d994b51c-xxxx-xxxx-b0d5-97a8923ab5t9",
             "client-request-id": "d302b51c-xxxx-yyyy-zzzz-12a8035ce9r9"
         }
     }
 }&nbsp;Any idea as to what I'm doing wrong?&nbsp;Thx

mark_rullo · Answer

Jeff Walzer&nbsp;Any luck?&nbsp; We're experiencing the same issue.

jeff walzer · Answer

Mark_Rullo&nbsp;&nbsp;I had to add the following to the Request headers:&nbsp;Key - ConsistencyLevelValue - eventual&nbsp;After I added that, I was able to run the search:&nbsp;https://graph.microsoft.com/beta/users?$count=true&amp;$filter=signInActivity/lastSignInDateTime+le+2022-09-01T00:00:00Z&amp;$filter=endsWith(mail,'@alumni.xxx.xxx')

mark_rullo · Answer

Jeff Walzer&nbsp;thank you for the quick response!&nbsp;https://graph.microsoft.com/beta/users?$filter=signInActivity/lastSignInDateTime le 2022-07-21T00:00:00Z&amp;$filter=userType eq 'Guest'&amp;$top=30&nbsp;I tried that and I got this:{&nbsp;&nbsp;&nbsp;&nbsp;"error":&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"code":&nbsp;"BadRequest",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"message":&nbsp;"Query&nbsp;option&nbsp;'$filter/filter'&nbsp;was&nbsp;specified&nbsp;more&nbsp;than&nbsp;once,&nbsp;but&nbsp;it&nbsp;must&nbsp;be&nbsp;specified&nbsp;at&nbsp;most&nbsp;once.",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"innerError":&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"date":&nbsp;"2023-01-17T00:45:17",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"request-id":&nbsp;"b1417012-d426-40d4-bc19-d44c07d1fedd",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"client-request-id":&nbsp;"b1417012-d426-40d4-bc19-d44c07d1fedd"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;}}

cloudhal · Answer

Jeff Walzer&nbsp;if you filter on signInActivity&nbsp;you cannot use any other filters, this is documented here&nbsp;https://learn.microsoft.com/en-us/entra/identity/monitoring-health/howto-manage-inactive-user-accounts&nbsp;It's an extremely annoying limitation.&nbsp;

Forum Discussion

How to use multiple filter operations in beta Graph API?

Share

Resources