This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am trying to run the following API:
https://graph.microsoft.com/beta/users?$count=true&$filter=signInActivity/lastSignInDateTime le 2022-09-01T00:00:00Z and endsWith(mail,'@alumni.xxx.xxx')
and I get the following response:
{
"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"
}
}
}
Any idea as to what I'm doing wrong?
Thx
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 0%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
Hello @Anonymous ,
Using the below endpoint, I am able to successfully run the query with below filters
https://graph.microsoft.com/beta/users?$count=true&$filter=signInActivity/lastSignInDateTime le 2022-09-01T00:00:00Z&$filter=endsWith(mail,'@alumni.xxx.xxx')
Hope this helps.
If the answer is helpful, please click Accept Answer and kindly upvote it. If you have any further questions about this answer, please click Comment.
TYVM for the reply - I added the request header ConsistencyLevel eventual and re-ran the query and I got results.
The issue now is after running that query and getting results, I'm not seeing the objects signInActivity or lastSignInDateTime for the users.
Also, I tried the same query in Postman (adding ConsistencyLevel eventual as a Header and I get this response:
{
"error": {
"code": "BadRequest",
"message": "Query option '$filter/filter' was specified more than once, but it must be specified at most once.",
"innerError": {
"date": "2022-12-22T20:49:10",
"request-id": "xxxxx",
"client-request-id": "xxxxx"
}
}
}