Find Jobs
Hire Freelancers

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

$30-250 AUD

I përfunduar
Postuar about 1 year ago

$30-250 AUD

Paguhet në dorëzim
[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.
ID e Projektit: 35768825

Rreth projektit

3 propozime
Projekt në distancë
Aktive 1 yr ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
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.
$240 AUD në 4 ditë
4,9 (9 përshtypje)
4,5
4,5
3 freelancers are bidding on average $313 AUD for this job
Avatari i Përdoruesit
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.
$200 AUD në 4 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i AUSTRALIA
Australia
5,0
5
Mënyra e pagesës u verifikua
Anëtar që nga nën 26, 2015

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.