"401: Unauthorized" error when exporting sub-sites

When you try to export sub-sites, you may get this error:

"System.Net.WebException: The request failed with HTTP status 401: Unauthorized."

The issue is due to the fact that the user you use to connect SQList to the SharePoint site does not have permission access some of the sub-sites.

If you need to export only the sub-sites at the certain levels, then selecting only those levels could resolve the issue (provided the right permissions) as SQList will not try to access all sub-sites at all levels.

Example settings for root and 1st levels only:



Some more details about this error can be found here:

https://social.msdn.microsoft.com/Forums/sharepoint/en-US/e6773082-cefa-4386-b53b-7dae7c1a94d8/getwebcollection-not-working?forum=sharepointdevelopmentlegacy

---

We are working on a change to SQList so that is some sub-sites are not accessible, SQList carries on with the others; we plan to release it in early October 2016.