The Export & Import module

Permissions

The endpoint is available to all with Wizdom admin permissions or to everyone as long as the database is in a migrated state. Every time the endpoint is called the database change to active state.​ So after a database is migrated this endpoint is available to be invoked one time and one time only without Wizdom admin permissions.

Invoke from Wizdom Admininstration

This functionality can be invoked from the Wizdom administration module “Export and import” under “Modules”. The page “Change mappings” will display a list of “From” and “To” values. Most of the “From” values will be provided by the application when the page is displayed. The “To” values are for the user to provide. If nothings is typed into the “To” value, that mapping set will be ignored. So the user do not need to provide “To” values for all the mappings that should not be changed. The new mappings a applied to Wizdom when the user click the “Apply mappings” button.

Invoke with Powershell​

Requires a trusted app registered in the domain.

• Create a Native client application in the Azure AD
  • Minimal required permissions are
    • ​Windows Azure Active Directory : Sign in and read user profile
    • Office 365 SharePoint Online : Read items in all site collections
• ​Download and install ADAL for PowerShell here: https://github.com/kenakamu/Microsoft.ADAL.PowerShell​
• Run this PowerShell:

​# Import Micrsoft.ADAL.Powershell module
Import-Module Microsoft.ADAL.Powershell

#ADAL – Creadentials
$user = “###”
$pass = “###”
#ADAL – authority ie. wizdom.onmicrosoft.com
$authority = “###”
#ADAL – clientId (guid)
$clientId = “###”
#ADAL – resourceId ie. https://wizdom.sharepoint.com/
$resourceId = “###”
#ADAL – accessToken
$accessToken = Get-ADALAccessToken -AuthorityName $authority -ClientId $clientId -ResourceId $resourceId -UserName $user -Password $pass

#Request
#The root of your Wizdom website ie. https://wizdom.azurewebsites.net
$wizdomHost = “###”
#A SharePoint sitecollection url ie. https://wizdom.sharepoint.com/sites/intranet
$sharepointHostUrl = “###”
$url = $wizdomHost + “/api/wizdom/exportimport/1/mappings” + “?sphosturl=” + $sharepointHostUrl
$headers = @{}
$headers[“Bearer”] = $accessToken
$headers[“x-wizdom-rest”] = “true”
#Request body – A json mapping schema
$postRequest = @”
{
  “urls”: [
{
  “from”: “”,
  “to”: “”
},
{
  “from”: “”,
  “to”: “”
}
],
  “domains”: [
{
  “from”: “”,
  “to”: “”
},
{
  “from”: “”,
  “to”: “”
}
],
  “users”: [
{
  “from”: “”,
  “to”: “”
}
],
  “clearAdminPermissions”: false
}
“@

Invoke-WebRequest -Uri $url -Method Post -Body $postRequest -ContentType “application/json” -Headers $headers