Get all level sub sites

Question

We have to get site hierarchy (rootweb – all level sub sites) and show it in a tree view using client object model (Provider hosted App)

We have implemented this by parsing through each site/web and making recursive calls which is affecting the performance. Reference - http://www.morgantechspace.com/2016/02/get-all-sites-and-subsites-in-sharepoint-online-csom.html

Is there any other way to get all the site and subsites(All levels) with minimal time and in a single call.

Answer 1

Regarding

Is there any other way to get all the site and subsites(All levels) with minimal time and in a single call.

search based approach could be more suitable in this regard (at least from performance perspective) as demonstrated below:

    public static List<WebInfo> GetAllWebs(ClientContext ctx)
    {
        var keywordQuery = new KeywordQuery(ctx)
        {
            QueryText = "contentclass:\"STS_Web\"",
            RowLimit = 500,
            StartRow = 0
        };
        keywordQuery.SelectProperties.Add("Title");
        keywordQuery.SelectProperties.Add("SPWebUrl");
        keywordQuery.SelectProperties.Add("Description");


        var searchExec = new SearchExecutor(ctx);
        var results = searchExec.ExecuteQuery(keywordQuery);
        ctx.ExecuteQuery();

        var resultTable = results.Value.FirstOrDefault();
        if (resultTable == null)
            return new List<WebInfo>();
        return resultTable.ResultRows.Select(row => new WebInfo()
            {
                Title = (string) row["Title"],
                Description = (string) row["Description"],
                AbsUrl = (string) row["SPWebUrl"]
            }).ToList();
    }

where

class WebInfo
{
    public string Title { get; set; }
    public string AbsUrl { get; set; }
    public string Description { get; set; }
}

Note: contentclass:"STS_Web" query targets web in search results

References

Search API usage in the SharePoint add-in model

SharePoint Power Searching Using ContentClass

Answer 2

please check this post Get the all sub sites from a site collection along with site hierarchy using CSOM

 using (var clientContext = new ClientContext(destinationSiteUrl))
           {
             clientContext.Credentials = new SharePointOnlineCredentials(UserName, secure);
             DataTable dtsubsites = new DataTable();
             Web oWebsite = clientContext.Web;
             clientContext.Load(oWebsite.Webs);
             clientContext.ExecuteQuery();
             var listclass = new List<webdetails>();
             var allWebs = new List<Web>();
             var objallWebs = LoadAllWebs(clientContext.Site.RootWeb, listclass, 0);
             GridView1.DataSource = objallWebs.ToList();
             GridView1.DataBind();
           }

     public class webdetails
      {
         public string csomweb { get; set; }
         public Int32 webhirarchy { get; set; }
      }

     public List<webdetails> LoadAllWebs(Web web, List<webdetails> allWebs,int level)
            {
                var ctx = web.Context;
                ctx.Load(web);
                ctx.Load(web.Webs);
                ctx.ExecuteQuery();
                // allWebs.Add(web);
                allWebs.Add(new webdetails { csomweb = web.Title, webhirarchy = level });
                foreach (var subWeb in web.Webs)
                {
                    LoadAllWebs(subWeb, allWebs, level+1);
                }
                return allWebs;
            }