Develop powershell

Summary: develop a new PowerShell script in Origihal.csv that creates users in DEV using the web services API CreateUserEx method (to create the user), followed by UpdateUserName method (to set the username correctly), followed by UpdateContactInfo method (to add the email).

Details:
Source data: results from below SQL
SELECT
username,
first_name,
last_name,
ISNULL(email,'') email,
ISNULL(title,'') title
FROM usr_staging s
WHERE
acct_status=1
AND NOT EXISTS(
SELECT *
FROM tbluser u
WHERE u.user_username = s.username)
ORDER BY s.Username;
Source data connection:
$InstanceName = server******,1888
$DatabaseName = 'Archi’'
$UserName = 'Archi'
$Password = '[to be sent separately
Target Archer Instance name: ArcherDEV
Target Archer username: api_users (will send PW separately)
Field mapping:
SQL Field
Archer Field
API Method
first_name
firstName
CreateUserEx
last_name
lastName
CreateUserEx
title
title
CreateUserEx
username
userName
UpdateUserName
email
ContactInfo
UpdateContactInfo