Powershell Script to convert JSON data from API to CSV (Carers)
$30-250 AUD
已完成
已发布大约 1 年前
$30-250 AUD
货到付款
[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.
Powershell expert.
I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom give me a chance to show you the best i can do at your service.
Dear my client. I am glad to see you and your job.
Your project is very interesting and I have done these kinds of projects before. You have chosen CSV file as the storage file, it's very good.
A CSV (comma-separated values) file is a text file that has a specific format which allows data to be saved in a table structured format.
Your project summary is very clear and I will satisfy your requirements. If you hire me, I will do my best. Thank you.