Sponsors field export

Question

Looking to export all the guest users along with the "Sponsors" field using - https://graph.microsoft.com/v1.0/users?$filter=userType+eq+'guest'&$select=id,displayName,mail,city,Sponsors

However, "Sponsors" doesn't show up.

Answer 1

That's because sponsors is a reference/navigation property, so you either need to use individual queries against /users/{id}/sponsors or leverage the $expand operator:

GET https://graph.microsoft.com/v1.0/users?$filter=userType+eq+'guest'&$select=id,displayName,mail,city&$expand=sponsors($select=id,userPrincipalName)