Cannot insert a null into column (callingsearchspacemember.sortorder)

Version 1
    This document was generated from CDN thread

    Created by: Lionel KEROGUES on 17-09-2009 07:42:41 AM
    Hello all,
     
    I am discovering AXL and  I 've already performed few tests whith some success.
    I have a trouble with updateCSS API.
    I can create a new CSS (addCSS), but when I want to add a partition to this new CSS (updateCSS), an error is thrown with the following message :
    "Cannot insert a null into column (callingsearchspacemember.sortorder)."
     
    I don't know how to populate this "sortorder" field.
     
    Do you have any idea ?
     
    Thanks for your help.
     
    Here is my code
     
     $client = new SoapClient("AXLAPI.wsdl",
                    array('trace'=>true,
                          'exceptions'=>true,
                          'location'=>$cucmapiurl,
                          'login'=>$cucmlogin,
                          'password'=>$cucmpwd,
                           ));
     
        $rsp_uCSS = $client->updateCSS(array('name'=>'CSS_TEST',
        'members'=>array('member'=>array('routePartition'=>array('name'=>'TEST_PUBLIC'),
            ),
          ),
        
        ));
     
    Regards.

    Subject: RE: Cannot insert a null into column (callingsearchspacemember.sortorder)
    Replied by: Lionel KEROGUES on 17-09-2009 12:12:22 PM
    Hello All,
     
    I found the trick.
    sortorder is the property "index" in axl.xsd.
    Now, it is Ok.
     
        $rsp_uCSS = $client->updateCSS(array('name'=>$CSSName,
        'members'=>array('member'=>array(array('routePartitionName'=>'TEST_PUBLIC',
             'index' => '508',
             ),
            array('routePartitionName'=>'TEST_PUBLIC_2',
             'index' => '509',
             ),
            ),
          ),
        ));
     
    Regards.