get active users only

Question

https://graph.microsoft.com/v1.0/groups/644172e5-7234-48e1-8b76-6ce80e377910/transitiveMembers/microsoft.graph.user?$count=true&$select=id,businessPhones,displayName,givenName,jobTitle,mail,mobilePhone,officeLocation,surname,userPrincipalName,department,companyName,streetName,city,state,postalCode,country,faxNumber,jobTitle,mailNickname,accountEnabled&$expand=manager($select=id,displayName,mail)&$filter=accountEnabled eq true i wants to get only active users using this query but it is not working then how can I do

Answer 1

Hi @Soumya Ranjan Sahoo

This is an expected error, because $filter=accountEnabled eq true is an advanced query, and advanced queries do not currently support $expand. You can only split it into two separate requests:

https://graph.microsoft.com/v1.0/groups/{group id}/transitiveMembers/microsoft.graph.user?$count=true&$select=id,businessPhones,displayName,givenName,jobTitle,mail,mobilePhone,officeLocation,surname,userPrincipalName,department,companyName,streetName,city,state,postalCode,country,faxNumber,jobTitle,mailNickname,accountEnabled&$filter=accountEnabled eq true

ConsistencyLevel: eventual

or

https://graph.microsoft.com/v1.0/groups/{group id}/transitiveMembers/microsoft.graph.user?$count=true&$select=id,businessPhones,displayName,givenName,jobTitle,mail,mobilePhone,officeLocation,surname,userPrincipalName,department,companyName,streetName,city,state,postalCode,country,faxNumber,jobTitle,mailNickname,accountEnabled&$expand=manager($select=id,displayName,mail)

Hope this helps.

If the reply is helpful, please click Accept Answer and kindly upvote it. If you have additional questions about this answer, please click Comment.