Develop powershell

Summary: develop a new PowerShell script in [login to view URL] 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 = [login to view URL]) ORDER BY [login to view URL]; 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