Find Jobs
Hire Freelancers

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.
项目 ID: 35768825

关于此项目

3提案
远程项目
活跃1 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 在4天之内
4.9 (9条评论)
4.5
4.5
3威客以平均价$313 AUD来参与此工作竞价
用户头像
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 在4天之内
0.0 (0条评论)
0.0
0.0

关于客户

AUSTRALIA的国旗
Australia
5.0
5
付款方式已验证
会员自11月 26, 2015起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。