How to get all SharePoint sites of organization using Microsoft Graph API?

Question

How to get all SharePoint sites of organization using Microsoft Graph API?

Casepoint Developer 66

Hello Team,

We are an eDiscovery Company and we want to build the same functionality as Microsoft eDiscovery (Purview) for Preservation of SharePoint sites.

We are using following API to preserve SharePoint site:
API : POST /compliance/ediscovery/cases/{caseId}/legalHolds/{legalholdId}/siteSources
document link : https://learn.microsoft.com/en-us/graph/api/ediscovery-legalhold-post-sitesources?view=graph-rest-beta&tabs=http

Here we need to pass SharePoint site URL in above API to preserve data of that site.

We want to provide SharePoint site selection option to the user and for that we want to know from which API we get a list of all sites of the organization?

Thanks & Regards

3 answers

Your answer

Answer 1

CarlZhao-MSFT 46,376

Hi @Casepoint Developer

Of course, you can use the search=* query parameter to list all sites in your organization. This method supports the Sites.Read.All delegated permission.

https://graph.microsoft.com/v1.0/sites?search=*

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.

CarlZhao-MSFT 46,376 Reputation points

2022-11-29T10:23:07.467+00:00

Hi @Casepoint Developer
Would you please provide us with an update on the status of your issue?
Casepoint Developer 66 Reputation points

2022-12-03T09:59:12.827+00:00

Hello @CarlZhao-MSFT

From Admin export, I have received 26 sites in files and in grid also it is showing 26 sites.

When I tried API - https://graph.microsoft.com/v1.0/sites?search=* , It is returning only 20 sites. So I think it is not returning all the sites of the organizations.

Can you please check this?

Thanks & Regards
Casual Dev 0 Reputation points

2023-05-26T16:13:49.8333333+00:00

Yes I believe you are correct. Delegated permissions will only show you the sites your account has access to. Application permissions will show you all sites however you may not be able to return specific information on those sites if you do not have access.

Answer 2

Vasil Michev 119.7K MVP Volunteer Moderator

You can use the /sites endpoint:

GET https://graph.microsoft.com/v1.0/sites

However, it will only work with APPLICATION permissions, not delegate ones. Refer to the official documentation for more info: https://learn.microsoft.com/en-us/graph/api/site-list?view=graph-rest-1.0

Casepoint Developer 66 Reputation points

2022-11-24T10:56:12.357+00:00

Hello @Vasil Michev ,

Thanks for the quick answer on this.

We are using following API to preserved data

API : POST /compliance/ediscovery/cases/{caseId}/legalHolds/{legalholdId}/siteSources
document link : https://learn.microsoft.com/en-us/graph/api/ediscovery-legalhold-post-sitesources?view=graph-rest-beta&tabs=http

As per the document, Application scope is not supported if we want to use above API.

And to get all sites we need to use this API "GET https://graph.microsoft.com/v1.0/sites" which supports only Application Scope.

So, how can we use both API together? Can you please suggest a way?

Thanks & Regards
Vasil Michev 119.7K Reputation points MVP Volunteer Moderator

2022-11-24T13:12:51.293+00:00

There's nothing preventing you from using both application and delegate permissions, get a token for each and use it as needed. Otherwise, you can explore other methods of getting the list of sites, such as using PowerShell or the PnP/CSOM methods.
Casepoint Developer 66 Reputation points

2022-11-25T09:54:29.707+00:00

Hello @Vasil Michev ,

To use both scopes (application & delegate), we need to ask client to do authentication process 2 times which looks practically wrong. Is there any way of authentication from where I can work with both kind of methods?

Thanks & Regards

Answer 3

CarlZhao-MSFT 46,376

Hi @Casepoint Developer

You can call the list sites api endpoint to list all available sites in your organization. Also, note that only application permissions are supported for listing all site collections.

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.

Casepoint Developer 66 Reputation points

2022-11-24T10:54:29.203+00:00

Hello @CarlZhao-MSFT ,

Thanks for the quick answer on this.

We are using following API to preserved data

API : POST /compliance/ediscovery/cases/{caseId}/legalHolds/{legalholdId}/siteSources
document link : https://learn.microsoft.com/en-us/graph/api/ediscovery-legalhold-post-sitesources?view=graph-rest-beta&tabs=http

As per the document, Application scope is not supported if we want to use above API.

And to get all sites we need to use this API "GET https://graph.microsoft.com/v1.0/sites" which supports only Application Scope.

So, how can we use both API together? Can you please suggest a way?

Thanks & Regards
CarlZhao-MSFT 46,376 Reputation points

2022-11-28T03:14:04.383+00:00

Hi @Casepoint Developer
Refer to my latest answer :)

Share via

How to get all SharePoint sites of organization using Microsoft Graph API?

3 answers

Your answer