Retrieve Site Collections And SubSites Using Microsoft Graph API

In this article, I have explained how to retrieve the top site collections and subsites using Microsoft Graph API. In my previous article, I have already written about how to fetch access token to authorize your web application with Microsoft Graph. Use the below link to learn about Microsoft Graph,

Let's get started to retrieve SharePoint top site collections and subsites using Microsoft Graph API

Retrieve SharePoint Tenant Root Site

EndPoint - https://graph.microsoft.com/sites/root

It returns the root site properties id, webUrl, displayName, CreateddateTime, LastModified etc...

Retrieve Site Collections And SubSites Using Microsoft Graph API

Retrieve Sharepoint Site Collection

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

Here we are using search equals to "*" to retrieve all the top level site collections from the SharePoint tenant host.

Code

function requestToken() {
$.ajax({
"async": true,
"crossDomain": true,
"url": "https://cors-anywhere.herokuapp.com/https://login.microsoftonline.com/sharepointtechie.onmicrosoft.com/oauth2/v2.0/token", // Pass your tenant name instead of sharepointtechie
"method": "POST",
"headers": {
"content-type": "application/x-www-form-urlencoded"
},
"data": {
"grant_type": "client_credentials",
"client_id ": "8baf0301-27df-44b1-b4fe-7911b9a918de", //Provide your app id
"client_secret": "tZ76oVPN039WlWPoAp+1aICq66vs7oUtE4lhDQYwxGY=", //Provide your secret
"scope ": "https://graph.microsoft.com/.default"
},
success: function(response) {
console.log(response);
token = response.access_token;
console.log(token);
getSiteInformation();
},
error: function(error) {
console.log(JSON.stringify(error));
}
})
}

Create a function "getSiteInformation" to initate the site collection request after successfully fetching the access token.

function getSiteInformation(){
$.ajax({
"async": true,
"crossDomain": true,
"url": "https://graph.microsoft.com/v1.0/sites?search=*",
"method": "GET",
"headers": {
"authorization": "Bearer" + token,
"content-type": "application/json"
},
success: function(response) {
console.log(response.value);
},
error: function(error) {
console.log(JSON.stringify(error));
}
})
}

After a successful response, it retrieves all 200 of my site collections from office 365 SharePoint.

Let's append it into a simple table to show the details of site collections

Final Result

Retrieve Subsite Using Microsoft Graph

EndPoint - https://graph.microsoft.com/v1.0/sites/{{site collection id}}/sites

Code

function getSubsite() {
$.ajax({
method: 'GET',
url: "https://graph.microsoft.com/v1.0/sites/sharepointtechie.sharepoint.com,1a634409-8e14-4d07-b1a7-366eec870233,4047d743-691c-4578-9795-4c1458096e98/sites",
headers: {
'Authorization': 'Bearer ' + token,
'Content-Type': 'application/json'
},
}).success(function(response) {
console.log(response.value);
var data = response.value;
for(var i=0; i<data.length; i++){
console.log(data[i].displayName);
var html = "<tr><td>" + data[i].displayName+ "</td><td>" + data[i].webUrl+ "</td><td>" + data[i].createdDateTime+ "</td>";
$('.table tbody').append(html);
}
}).error(function(error) {});
}

Response

Finally, we retrieved the subsites using Microsoft Graph API.

So, this article will help you to retrieve the Sharepoint top-level site collection and subsite of the site collections.