SharePoint Get all sites and all sub sites using SharePoint online REST API

Question

For SharePoint Online connector We used following steps to fetch all sites:

Step 1: Created Add-in on SharePoint instance with following permission xml

<AppPermissionRequests>
        <AppPermissionRequest Scope="http://sharepoint/content/tenant" Right="FullControl"/>
        <AppPermissionRequest Scope="http://sharepoint/content/sitecollection" Right="Read"/>
</AppPermissionRequests>

Step 2: Used below API to get all sites and subsites

https://<site_name>.sharepoint.com/_api/search/query?querytext='contentclass:STS_Site' &rowlimit=100

Issue we are facing –

Above endpoint is returning all sites, sub sites along with user’s personal site(One drive), while we need all sites and sub sites only.
Please suggest minimal required permission to read all site, all subsite, all folders and files metadata

We referred following links:

score 3 · Answer 1 · answered Aug 01 '18 at 02:51

A way from Joel Dsouza for your reference.

1.The First Ajax is to get the Root Site Title and the Relative URL.

$.ajax({
    url: _spPageContextInfo.siteAbsoluteUrl + "/_api/site/rootweb?$select=Title,ServerRelativeUrl",
    method: "GET",
    headers: {
        "Accept": "application/json; odata=verbose"
    },
    success: function(rootsite) {

    },
    error: function(rootsite) {},
    async: false
});

2.The Second AJAX is to get all the sub sites under the Root Site.

$.ajax({
    url: _spPageContextInfo.siteAbsoluteUrl + "/_api/web/webinfos?$select=ServerRelativeUrl,Title",
    method: "GET",
    headers: {
        "Accept": "application/json; odata=verbose"
    },
    success: function(subsites) {
        $.each(subsites.d.results, function() {
            getSubSites(this.ServerRelativeUrl, this.Title);
        });

    },
    error: function(subsites) {},
    async: false
});

3.This is a Recursive Function to loop through the sub sites and check for more sub sites.

function getSubSites(SubSiteUrl, SubSiteTitle) {
    console.log(SubSiteUrl);
    $.ajax({
        url: _spPageContextInfo.siteAbsoluteUrl + SubSiteUrl + "/_api/web/webinfos?$select=ServerRelativeUrl,Title",
        method: "GET",
        headers: {
            "Accept": "application/json; odata=verbose"
        },
        success: function(subsites) {

            $.each(subsites.d.results, function(index) {
                getSubSites(this.ServerRelativeUrl, this.Title);
            });
        },
        error: function(subsites) {},
        async: false
    });
}

More information: Get All Sites and Sub Sites using REST API

I don't want to hit multiple API for that. As suggested by @gautam I am able to get expected result. Thanks for the answer — Darshan Patel, Aug 01 '18 at 17:28

Gautam Sheth · Accepted Answer · 2018-08-01T08:51:55.840

2

You should add a path filter in the endpoint.

Normal site collections have a path like https://tenant.sharepoint.com whereas personal (One Drive) site collections have path like https://tenant-my.sharepoint.com/personal/*.

So, modify your endpoint as below:

https://<site_name>.sharepoint.com/_api/search/query?querytext='contentclass:STS_Site
Path:"https://<site_name>.sharepoint.com/*"'&rowlimit=500

This will only return site collections starting with https://<site_name>.sharepoint.com path and will exclude the One Drive site collections which are on a different path.

edited Aug 01 '18 at 08:51

answered Aug 01 '18 at 04:48

Gautam Sheth

2,442
1
17
16

Thanks Gautam `` Could you please correct me on the Add-in permission part. I need to set read permission only. please check updated question Thanks – Darshan Patel Aug 01 '18 at 17:30
If its just for display/retrieval purposes, then read permission would be enough. But if you need to do more processing on it, then you will need higher permissions – Gautam Sheth Aug 01 '18 at 17:45
yes, its only for /retrieval. I think following permissions would be sufficient. ` ` Please correct me if I am wrong – Darshan Patel Aug 01 '18 at 18:03

score 0 · Answer 3 · answered Feb 01 '19 at 16:35

https://yoursharepointsite.com/_api/search/query?querytext='(contentclass:STS_Site) (contentclass:STS_Web)'&trimduplicates=false&rowlimit=5000&selectproperties='Title,Url,Path,ParentLink'"

The above rest url shoul give you all the Sites and subsite the user has access to. You may need to trim duplicates.

SharePoint Get all sites and all sub sites using SharePoint online REST API

3 Answers3

Linked