Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
<#
.SYNOPSIS
Generates the STSSyncURLs for a Sharepoint Online Site using CSOM. Should be run from a SharePoint server.
TODO: identify which DLL contains the microsoft.sharepoint.utilities.spencode method to allow running without a SharePoint install.
.DESCRIPTION
This script is useful for generating a long list of STSSYNC urls without tediously connecting dozens of lists to Outlook, sharing them, and extracting
the URL in that fashion. The output is a PSOBject which can be piped to a CSV for further manipulation, or to a separate script that creates appropriate GPOs
or .REG files for further automation.
Requires load-csomproperties.ps1 from: https://gist.github.com/glapointe/cc75574a1d4a225f401b
.EXAMPLE
.\get-spostssyncurls.ps1 | export-csv "urls.csv"
.NOTES
Author : Quinten Steenhuis
.LINK
https://nonprofittechy.blogspot.com
.LINK
https://msdn.microsoft.com/en-us/library/dd957390(v=office.12).aspx
#>
$cwd = split-path $myinvocation.mycommand.path
. (join-path $cwd "load-csomproperties.ps1")
<#
Add-Type -Path "C:\Program Files\SharePoint Online Management Shell\Microsoft.Online.SharePoint.PowerShell\Microsoft.SharePoint.Client.dll"
Add-Type -Path "C:\Program Files\SharePoint Online Management Shell\Microsoft.Online.SharePoint.PowerShell\Microsoft.SharePoint.Client.Runtime.dll"
#>
$stsbase = "stssync://sts/?ver=1.1"
$rootURL = "https://MYCOMPANY.sharepoint.com"
$baseUrl = "https://MYCOMPANY.sharepoint.com/Units"
$adminURL = "https://MYCOMPANY-admin.sharepoint.com"
$username = "user@MYCOMPANY.com"
$password = Read-Host -Prompt "Enter password" -AsSecureString
$clientContext = New-Object Microsoft.SharePoint.Client.ClientContext($baseUrl)
$credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($username, $password)
$clientContext.Credentials = $credentials
if (!$clientContext.ServerObjectIsNull.Value)
{
Write-Host "Connected to SharePoint Online site: '$baseURL'" -ForegroundColor Green
}
$rootWeb = $clientContext.Web
$childWebs = $rootWeb.Webs
$clientContext.Load($rootWeb)
$clientContext.Load($childWebs)
$clientContext.ExecuteQuery()
function get-stssyncurl ($list) {
$encoded = $stsbase + "&type="+$list.type+"&cmd=add-folder"
$ht = @{
"base-url" = $list.baseURL;
"list-url" = $list.listurl;
"guid" = "{" + $list.guid + "}";
"site-name" = $list.sitename;
"list-name" = $list.listname
}
foreach ($h in $ht.getEnumerator()) {
$encoded += "&" + $h.key + "=" + [microsoft.sharepoint.utilities.spencode]::urlencode($h.value)
}
foreach ($rep in $repl) {
$encoded = $encoded -replace $rep.key,$rep.value
}
# these characters appear to need /additional/ escaping, after urlencoding
# and the hex value should be preceded by a vertical bar |
# & \ [ ] |
$replPostRegex = "(%26)|(%5C)|(%5B)|(%5D)|(%7C)"
$encoded = $encoded -replace $replPostRegex,'|$1'
return $encoded
}
function processWeb($web)
{
# Skip some lists we'll never want to connect to Outlook
$exclude = @(
"Site Assets",
"Site Pages",
"MicroFeed",
"Master Page Gallery",
"Workflow History",
"Workflow Tasks",
"Workflows",
"wfsvc",
"Images",
"Pages",
"Composed Looks",
"Master Pages",
"Long Running Operation Status",
"Notification List"
"Project Policy Item List",
"Quick Deploy Items",
"Relationships List",
"Reusable Content",
"Site Collection Documents",
"Site Collection Images",
"Solution Gallery",
"Style Library",
"Suggested Content Browser Locations",
"TaxonomyHiddenList",
"Theme Gallery",
"Translation Packages",
"Translation Status",
"User Information List",
"Variation Labels",
"Web Part Gallery",
"wfpub",
"appdata",
"Form Templates",
"Cache Profiles",
"Access Requests",
"Content and Structure Reports",
"Content type publishing error log",
"Converted Forms",
"Device Channels",
"fpdatasources",
"List Template Gallery"
)
$lists = $web.Lists
$clientContext.Load($web)
$clientContext.Load($lists)
$clientContext.ExecuteQuery()
$lists = $lists | where {-not ($exclude -contains $_.Title)}
$siteName = $web.Title
foreach ($list in $Lists)
{
# using Gary Lapointe's implementation of lambda function to simplify loading Sharepoint Online CSMO properties -- Views property not loaded by default
Load-CSOMProperties -object $list -propertyNames @("Views","rootFolder")
$clientContext.ExecuteQuery()
$views = @()
foreach ($view in $list.Views) {
$views += $view.Title
}
# if the baseType is "genericlist" we need to try searching the view types to determine which type of list this is
# for Outlook equivalent
$type = switch ($list.basetype) {
"DocumentLibrary" {"documents"; break}
"GenericList" {
switch ($views) {
"Threaded" {"discussions"; break}
"Calendar" {"calendar"; break}
"All Tasks" {"tasks"; break}
"All Contacts" {"contacts"; break}
};
break
}
}
$listURL = ($rootURL + $list.rootFolder.ServerRelativeURL).substring($web.URL.length)
$retval = @{
"type" = $type;
"views" = $list.Views;
"baseURL" = $web.URL;
"listurl" = $listURL;
"GUID" = $list.ID;
"listName" = $list.Title;
"siteName" = $siteName;
}
new-object psobject -property $retval
}
}
$lists = @()
$lists += processWeb($rootweb)
foreach ($childWeb in $childWebs)
{
$lists += processWeb($childWeb)
}
foreach ($list in $lists) {
new-object psobject -property @{
"siteName" = $list.siteName;
"listName" = $list.listName;
"stssyncurl" = (get-stssyncurl -list $list);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment