Adding Phone-Line and Associating Enduser thru AXL-API

[maqsood ahmed]

Can Anybody help with correct AXL API's  for  Adding JABBERDevice  (CSF) ,   LineNumber  and Associating its Enduser-ID 

 thru AXL-API for cucm 12.5    in a  single   API  Transaction. 

 I can add a single device  and line numbers separately , but cannot associate it with both. 

[LanDownUnda]

Hi Maqsood,

Just to clarify, your looking for a single call to the AXL-API that can do the following:

1. Create a CSF (Jabber) Device and assign a Line Number
2. Associate the newly created CSF Device to an End User

From looking at the Documentation I can't see a particular service that can do all 3 things for you. You could however build out a simple API Gateway and link all 3 seperate API calls off that? Here is an example:

1. Call the CSF Build API - https://yourbusiness.com/newstarter/deploysoftphone

2. /deploysoftphone then sends 3 calls to Create the CSF, Assign a Line Number then Associate the CSF with the end user.

If you haven't already done so, you can integrate common Enterprise Directories like Active Directory into CUCM so new users that are created in AD can be added to CUCM.

[maqsood ahmed]

yes, u r two assumption is right  but 

This  url  doesn't work : https://yourbusiness.com/newstarter/deploysoftphone 

[dstaudt]

<addPhone> can not directly associate the User. You must use <add | updateUser> to associate Users with Phones:

--> <addLine>
--> <addPhone><lines><line><dirn>
--> <addUser><associatedDevices>

[maqsood ahmed]

Currently  i am using  3 seperate  API's to add device add  update user ..  i face a lot of issue  like:

1. when i add  device  ,, it doesn't  populate sip profile  under device page ,

                                Example: <sipProfileName uuid="?">Jabber-For-Android-Sip-Profile</sipProfileName>

additionally i cannot  associate a line index to the added device ,,

2. Still try to get a single API  to add device and also associate a primary line to the added device 

the only part working good for me is  updateUser

Pls if u can show me the  API with example..

thanks

[dstaudt]

I've added the sipProfileName field to the Python example here, if it helps: https://github.com/CiscoDevNet/axl-python-zeep-samples/blob/master/axl_add_User_Line_Phone.py

Its working for me on CUCM 12.5...

Unfortunately, creating each of the three objects you want to associate - line/phone/user - requires three separate AXL requests.  Perhaps if we can understand your requirement to do it in 'one shot' in more detail we can make some alternate suggestions..?

Note, it may theoretically be possible to do something using multiple transactions in an <executeSqlUpdate> request, as you can include multiple SQL statements in one request:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/12.5">
   <soapenv:Header/>
   <soapenv:Body>
      <ns:executeSQLUpdate sequence="1">
         <sql>insert into numplan... ;
              insert into device... ;
              insert into user... ;
              insert into devicenumplan map... ;
              insert into enduserdevicemap ...;
       	</sql>
      </ns:executeSQLUpdate>
   </soapenv:Body>
</soapenv:Envelope>

However this would require extensive knowledge of the CUCM database schema, the order/tables/fields and object relationships used when creating each type of object, and extensive SQL experience.  The result would likely be difficult to maintain/expand, and could be brittle across CUCM versions.