I need to use AXL to add a single device to an application users existing associated devices. Im thinking to do this Ill have to use updateAppUser, specify associatedDevices, and include all the currently associated devices in addition to the extra single device I want to associate. Is that correct? Is there an easier way to add just a single device, without having to include all existing devices as well?
Solved! Go to Solution.
You are correct, as far as the standard AXL requests: use <updateAppUser> and specify the new (complete) set of associated devices.
Note, it is possible to modify the associations via <executeSqlUpdate> by modifying the CUCM database via direct SQL. See the 'applicationuserdevicemap' table. An example:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/10.5">
<soapenv:Header/>
<soapenv:Body>
<ns:executeSQLUpdate sequence="1">
<sql>insert into applicationuserdevicemap (pkid,fkapplicationuser,fkdevice,tkuserassociation) values (newid(),"ca121da0-683f-0886-1dd1-fe8abdcd149c","02bb0c13-376d-08e0-b6de-77362cedb79a",1)</sql>
</ns:executeSQLUpdate>
</soapenv:Body>
</soapenv:Envelope>
You are correct, as far as the standard AXL requests: use <updateAppUser> and specify the new (complete) set of associated devices.
Note, it is possible to modify the associations via <executeSqlUpdate> by modifying the CUCM database via direct SQL. See the 'applicationuserdevicemap' table. An example:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/10.5">
<soapenv:Header/>
<soapenv:Body>
<ns:executeSQLUpdate sequence="1">
<sql>insert into applicationuserdevicemap (pkid,fkapplicationuser,fkdevice,tkuserassociation) values (newid(),"ca121da0-683f-0886-1dd1-fe8abdcd149c","02bb0c13-376d-08e0-b6de-77362cedb79a",1)</sql>
</ns:executeSQLUpdate>
</soapenv:Body>
</soapenv:Envelope>