SharePoint Online Connector Scripts
Gimmal provides a number of scripts to aid technical users in administrative functions for the SharePoint Online Connector (SPOC).
These scripts are provided for informational purposes with the assumption that the user will be well-versed in using PowerShell for a SharePoint environment.
These scripts are provided without any explicitly or implicitly granted warranties or guarantees. They have been successfully used internally by Gimmal/Morae Client Services, but should not be considered production-ready off-the-shelf software.
Clients are responsible for their own verification and testing in/by the client's own DEV/TEST environment BEFORE using it within a PRODUCTION environment.
Register New Sites
This script (SPOCRegisterSite.ps1)is used to register new SharePoint Online sites for management by Gimmal Records where the user interface is not sufficient or cumbersome (e.g., a large number of sites). It takes a CSV file as input.
See notes inside the script for more information on deployment.
Replace Add In with new App Package
This script (ReplaceSharePointConnectorAddins.ps1) will remove the legacy SharePoint Online Connector (SPOC) App on sites listed in an associated CSV file and replace it with the updated SPOC app. This is useful for clients with a large number of deployed sites.
ReplaceSharePointConnectorAddin.ps1
Assign Sites. Selected Permissions
Following Microsoft’s guidance, Gimmal recommends establishing FullControl.All permission as part of the application registration process. For limiting permissions, our Professional Services team has had success using Sites.Selected. To add sites to the permissions for the application, a script like the one below (AssignSitesSelectedPermission) can be used.
Note: Any new site that is registered must also be added to the app registration.