Using AXL to change userid in 7.1(3) for End User

Version 1
    This document was generated from CDN thread

    Created by: WILL DELAUGHTER on 06-12-2010 10:26:37 PM
    Is there a method for changing the userID for End User's in CUCM 7.1(3)?  I have been trying something like the below:
     
    <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <SOAP-ENV:Body>
    <axl:updateUser xmlns:axl="http://www.cisco.com/AXL/API/1.0" sequence="1">
         <userid>Olduser</userid>
         <newUserId>Newuser</newUserId> 
    </axl:updateUser>
    </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>
     
    but I have had no success with this.  I've also tried newuser, newuserid, newUserid, and newUserID.  If updateuser doesn't have a method for changing the userid name, what would be the equivalent SQL syntax to change it that way (if possible)?

    Subject: RE: Using AXL to change userid in 7.1(3) for End User
    Replied by: WILL DELAUGHTER on 06-12-2010 10:57:45 PM
    Thanks for the quick response.  The SQL query you provided seems to have done the trick.

    Subject: RE: Using AXL to change userid in 7.1(3) for End User
    Replied by: David Staudt on 06-12-2010 10:47:58 PM
    There is a <newUserid> in UCM 8.0, but not in 7.1(3).  You will need to use <executeSQLUpdate> for this, e.g.:
     

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/7.1">
       <soapenv:Header/>
       <soapenv:Body>
          <ns:executeSQLUpdate sequence="1">
             <sql>update enduser set userid='testUserNew' where userid='testUser'</sql>
          </ns:executeSQLUpdate>
       </soapenv:Body>
    </soapenv:Envelope>