Graph API - Get list of SharePoint sites with Sites.Selected

Question

Hi there,

I'm building an integration with SharePoint using the Graph API. I have an Azure AD application with the Site.Selected permission and consent is granted. I have also granted read/write permissions to this application for a number of sites in SharePoint. When using the Microsoft Graph SDK in C#, I'm unable to get a list of sites that the application has read access to, but I am able to get details for individual sites. For reference:

GraphServiceClient graphClient = GetGraphClient(); // Setup with client credentials (app-based authentication)
var sites = await graphClient.Sites.GetAsync(); // List of sites is empty, even though the application has read access to some sites
var site = await graphClient.Sites["Id from one of the sites the app has read permissions"].GetAsync(); // Site details are returned

The fact that I can get individual site details tells me that everything is setup correctly. Is there a way to query all sites that my application has read permissions without requesting full read/read permission to all sites in SharePoint?

Thanks

Answer 1

Hi @Billy

Please try the code below. Judging by obtaining the information of the site

GraphServiceClient graphClient = GetGraphClient(); 
var sites = await graphClient.Sites.Request().Expand("permissions").GetAsync();

var filteredSites = sites.Where(site => site.Permissions.Any(permission => permission.Roles.Any(role => role.Id == "Sites.Read.All")));

foreach (var site in filteredSites)
{
    Console.WriteLine($"Site: {site.Id} - {site.DisplayName}");
}

---

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

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Best Regards

Cheng Feng