powershell module for querying oneroster api to a Microsoft SDS csv set

Find a file

fffnite db64e5b1f7 Merge pull request #2 from the-glasgow-academy/dev Refactor blacklist out of main script file Add timer check for JWT renewal Update blacklist to current requirements		2020-09-04 20:56:14 +01:00
blacklist.ps1	Fix class blacklist string	2020-09-04 16:47:55 +01:00
ConvertFrom-K12.ps1	Add convert function to local module	2019-09-04 13:54:32 +01:00
README.md	Update and tidy readme	2020-09-04 18:08:28 +01:00
sds-ms.ps1	Split blacklist to seperate file, add time-checking to token	2020-09-04 16:35:12 +01:00

README.md

Oneroster API to CSV for MS SDS

This script calls against a Oneroster compliant API to build CSV files compatible with the UK standard CSV required by Microsoft School Data Sync.

This includes modifiable filters for creating bespoke blacklists for unsuitable or uncompliant content with MS SDS.

Usage

Requires: PowerShell Core (linux/mac/windows)

$VerbosePreference = 'continue'
$env:OR_URL = 'https://my-oneroster-api/ims/oneroster/v1p1'
$env:OR_CI = read-host #api client id
$env:OR_CS = read-host #api client secret

./sds-ms.ps1

This will generate 6 csvs under ./csv-sds folder. Upload these to you MS SDS profile.

Omit entries

You may need to omit results from being added to your MS SDS sync, editing the where-object options under the blacklistUsers and blacklistClasses functions in blacklist.ps1 will allow you to remove entries based on any available source values.