Log In
Developer Network
Technologies
Join the Network
Member Services
Events & Community
Unified Presence APIs (CUPAPI) Developer Center
Overview
Overview Of Interfaces
XMPP
BOSH
SIP/SIMPLE
SOAP
REST
System Architecture
CAXL SDK
Overview
Compatibility
Documentation
Download
Resources
Client Configuration Web Service
Presence Web Service
Web Services Reference Application
Platform SOAP Service
Documentation
Community
Testing
Resources
Support & Services
Everything
This Site
Blogs
Cisco Live! London - Jan 29/Feb 2, 2011
Cisco Live! London - Jan. 31-Feb 3, 2011
RSS
(Opens New Window)
Showing 2 results.
Forums
Message Boards Home
Recent Posts
Statistics
Answer
(
Unmark
)
Mark as an Answer
« Back to SOAP API
tables used in the cucm db for cups
Threads [
Previous
|
Next
]
Stephan Steiner
Posts:
8
Join Date:
6/17/08
Recent Posts
tables used in the cucm db for cups
Answer
6/9/11 12:13 PM
Mark as an Answer
Submit
Reply with Quote
Quick Reply
Is there any documentation as to which tables are used for cups in the cucm database? So far I've only managed to find the two cups fields on the enduser, but there must be a lot more (I'm specifically looking for a list of voicemail profiles, conferencing profiles, ldap profiles, audio profiles and ccmcip profiles and where those values are set on a user)
Sign in to vote.
Flag
Please sign in to flag this as inappropriate.
Top
Doug Kartio
Posts:
6
Join Date:
4/13/11
Recent Posts
RE: tables used in the cucm db for cups
Answer
6/9/11 2:02 PM as a reply to Stephan Steiner.
Mark as an Answer
Submit
Reply with Quote
Quick Reply
I had these same questions a few weeks ago.
I talked about it on the AXL forum:
http://developer.cisco.com/web/axl/forums/-/message_boards/view_message/3830374
There is a WSDL in the axltoolkit within the CUPS plugin menu. This is a different axltoolkit than in the CM plugin directory.
There you will find the updateUpcUserSettings, those handle the settings you are looking for.
This documentation is old, but still fairly good.
http://www.cisco.com/en/US/docs/voice_ip_comm/cups/6_0_1/interoperability/developer/guide/cpsinter.html#wp73904
You can fill in the blanks and bring our mental model up to date by downloading the AXL WSDL from CUPS. Then by using soapUI, one can parse the WSDL and create a prototype request, which gives you the following:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/8.0">
<soapenv:Header/>
<soapenv:Body>
<ns:updateUpcUserSettings sequence="?">
<!--You have a CHOICE of the next 2 items at this level-->
<uuid>?</uuid>
<userid>?</userid>
<!--Optional:-->
<voicemailprofile uuid="?">?</voicemailprofile>
<!--Optional:-->
<ctigatewayprofile uuid="?">?</ctigatewayprofile>
<!--Optional:-->
<conferencingprofile uuid="?">?</conferencingprofile>
<!--Optional:-->
<ldapprofile uuid="?">?</ldapprofile>
<!--Optional:-->
<audioprofile uuid="?">?</audioprofile>
<!--Optional:-->
<ccmcipprofile uuid="?">?</ccmcipprofile>
</ns:updateUpcUserSettings>
</soapenv:Body>
</soapenv:Envelope>
Hope that helps
Sign in to vote.
Flag
Please sign in to flag this as inappropriate.
Top
Stephan Steiner
Posts:
8
Join Date:
6/17/08
Recent Posts
RE: tables used in the cucm db for cups
Answer
6/10/11 10:16 AM as a reply to Doug Kartio.
Mark as an Answer
Submit
Reply with Quote
Quick Reply
Doug - exactly what I was looking for. Thanks
Sign in to vote.
Flag
Please sign in to flag this as inappropriate.
Top
Doug Kartio
Posts:
6
Join Date:
4/13/11
Recent Posts
RE: tables used in the cucm db for cups
Answer
6/10/11 2:27 PM as a reply to Stephan Steiner.
Mark as an Answer
Submit
Reply with Quote
Quick Reply
No problem, glad I could help
Sign in to vote.
Flag
Please sign in to flag this as inappropriate.
Top
Stephan Steiner
Posts:
8
Join Date:
6/17/08
Recent Posts
RE: tables used in the cucm db for cups
Answer
6/10/11 3:49 PM as a reply to Doug Kartio.
Mark as an Answer
Submit
Reply with Quote
Quick Reply
Small followup.. did it work out for you? I managed to extract users, settings and potential values for those user configurable fields.. but even sending the same uuid/name pair for each XFKType back returns a useless error (axlcode = -1, axlmessage empty) - this is using a .NET stub created as per Cisco's instructions.
I'm currently triyng to go the old "write the xml on your own" route where I can play with the syntax in the hope that cups will eventually accept something that I'm sending to it.
@edit.. using SoapUI I managed to quickly try out various ways of sending the update request.. here's how the user looks that I'm trying to modify
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<ns:listUpcUserSettingsResponse xmlns:ns="http://www.cisco.com/AXL/API/8.5">
<return>
<upcUserSettings uuid="{3CCDA087-5ADE-4733-93D7-238B0122590A}">
<userid>register</userid>
<voicemailprofile uuid="{75224352-9994-189C-595E-A6A233DEB1FE}">p_Unity</voicemailprofile>
<ctigatewayprofile uuid="{4200D77E-8E83-4163-AC01-20420A9A3E7E}">Default_Profile</ctigatewayprofile>
<conferencingprofile/>
<ldapprofile/>
<audioprofile/>
<ccmcipprofile/>
</upcUserSettings>
</return>
</ns:listUpcUserSettingsResponse>
</soapenv:Body>
</soapenv:Envelope>
if I then send a
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/8.5">
<soapenv:Header/>
<soapenv:Body>
<ns:updateUpcUserSettings sequence="?">
<userid>register</userid>
<voicemailprofile>p_Unity</voicemailprofile>
<ctigatewayprofile>Default_Profile</ctigatewayprofile>
<conferencingprofile/>
<ldapprofile/>
<audioprofile/>
<ccmcipprofile/>
</ns:updateUpcUserSettings>
</soapenv:Body>
</soapenv:Envelope>
I get the following back
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<soapenv:Fault>
<faultcode>soapenv:Server</faultcode>
<faultstring/>
<detail>
<axlError>
<axlcode>-1</axlcode>
<axlmessage/>
<request>updateUpcUserSettings</request>
</axlError>
</detail>
</soapenv:Fault>
</soapenv:Body>
</soapenv:Envelope>
I've also tried using lines like <ldapprofile uuid=""></ldapprofile>, as well as <ldapprofile></ldapprofile> and of cours specifying the uuid where applicable (just copied the lines I got for my listUpdUserSettings request) to no avail.
Sign in to vote.
Flag
Please sign in to flag this as inappropriate.
Top
Randy Watson
Posts:
1
Join Date:
5/16/11
Recent Posts
RE: tables used in the cucm db for cups
Answer
6/17/11 11:57 AM as a reply to Stephan Steiner.
Mark as an Answer
Submit
Reply with Quote
Quick Reply
Is there also a parameter to pullout and display the watchers. Unfotunately, the product does not have an ASK first option for people in the company.
You can only block or allow and to block all is not really a good option because then you have everyone asking others for permission to see them.
Any help would be appreciated
Sign in to vote.
Flag
Please sign in to flag this as inappropriate.
Top
Collateral
No files available