Powershell Script to convert JSON data from API to CSV (Carers)

[login to view URL] Project summary Develop a Powershell script that can connect to an enterprise application using a rest API. The script will manipulate the data and export a series of CSV files. API documentation [login to view URL] The API calls required for this script are: • Authorisation • Get contacts API Endpoints The script will need extract data from multiple systems (later referred to as colleges) using differing client secret details. The script will need to reference a college definition file that has this information. Each college also has the following attributes: • $CollegeLong • $CollegeShort Ideally, the database connection functionality should be contained in a separate script so that it can be called by other future scripts. Data required It should be noted that ‘Get-Contacts’ only returns 100 records at a time so the pagination will need to be recursed through. The script shall extract the the following records: • scope = Current & Future • contactType = carer The records shall be populated into a CSV with the following field mapping: • first_name  firstname • last_name  surname • email  email_address • recovery_phone  mobile_phone • recovery_email  email_address • sis_id  username • role  “Parent” • password  first and last initial + birthdate reformatted as DDMMYY eg cw150389 • user_name  username • college  $CollegeLong • launch_url  https://$[login to view URL] • app_url  "" How will the script be executed? The script will be executed by cron on a unix machine. Output The script shall output the following: 1. A CSV file containing the data for each college “parents\$[login to view URL]” 2. A CSV file containing all the data combined “parents\[login to view URL]” 3. A log file indicating the number of records extracted or the error Other Notes 1. Script should be well documented/commented with all inputs defined as variables.