update MWI status over SOAP

Version 1
    This document was generated from CDN thread

    Created by: kaiser cheng on 08-09-2009 11:48:04 AM
    Dear sir,
     
    We used to turn MWI on/off via TAPI,
    can we do it by SOAP?
    I saw a doc said AXL is limited MWI status update, really?
     
    kaiser

    Subject: RE: update MWI status over SOAP
    Replied by: David Staudt on 08-09-2009 12:56:42 PM
    MWI status is not settable via AXL.  You can use AXL to set some MWI policies on thie phone (light-only vs light/message vs light/message/sound, etc.) but TAPI or JTAPI is needed to actively set/unset the MWI.

    Subject: RE: update MWI status over SOAP
    Replied by: David Staudt on 10-09-2009 12:50:50 AM
    It looks like you can get MWI set/unset by updating a special UCM table via <executeSQLUpdate>:
     
    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/7.0">
       <soapenv:Header/>
       <soapenv:Body>
          <ns:executeSQLUpdate sequence="1">
             <sql>update numplandynamic set tklampblinkrate_messagewaiting=2 where fknumplan='e3addec9-8e96-fefa-1aa0-59ce630d49ce'</sql>
          </ns:executeSQLUpdate>
       </soapenv:Body>
    </soapenv:Envelope>
     
    The value '2' here means MWI on, '1' means MWI off.  See the Data Dictionary for additional details on numplandynamic.

    Subject: RE: update MWI status over SOAP
    Replied by: Stephan Steiner on 16-09-2009 02:39:45 PM
    David... does the mwi state really change though? The DB would have to have a trigger on that field which would launch whatever code is to be run when the MWI state is to be changed.
    So far I've always used JTAPI to change MWI state.

    Subject: RE: update MWI status over SOAP
    Replied by: kaiser cheng on 17-09-2009 07:59:34 AM
    I have test david's sql, 
    it works!!