Contents
This will only return site collections starting with https:// .sharepoint.com path and will exclude the One Drive site collections which are on a different path. A way from Joel Dsouza for your reference.
For SharePoint Online connector We used following steps to fetch all sites: Step 1: Created Add-in on SharePoint instance with following permission xml 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. You should add a path filter in the endpoint.
How to retrieve all subsites and subsite members in SharePoint?
Let’s narrow a bit, and retrieve only the sub-subsites for one subsite ( i.e.: Subsite B) In case you need to get specific information, pipe the cmdlet to Get-Member, and choose amongst more than 170 methods and properties! ( at the time of writing: March 2018)
This query gets all sites and selects the logo and title. You can modified to get more properties. That’d also get you back all sites, but for simplicity (and if you’re using on prem) you can just use search. This way you’re getting only sites under /sites. or you can have something like /sites/p* to have all sites starting with the letter p.
Using the SharePoint Online REST API, I’m trying to retrieve a list of all sites and subsites. Either of these APIs gives me all sub-sites of the root top level site:
The ParentLink property contains the base URL for the site/sub-site. While this is correct, it just feels like the wrong way of doing things. This method also does not return the actual name of the site/sub-site, so is only a partial answer, but the best I can find right now. If you can use the Microsoft Graph, it’s much easier…
How can I get a list of all subsites?
Check the below screenshot which shows the deep subsite. ✅ If you just want to get a list of site & subsite URLs, you can cheat slightly. Instead of looking for the sites or subsites, look for a /path/to/newsfeed.aspx entry instead. This appears to be present for all sites and subsites.