12-03-2017 11:44 PM
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.
12-04-2017 08:22 AM
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>
12-04-2017 08:22 AM
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>
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide