update fields with soap(SoapSugarUsers.php)

[shahrzad]

hi dears,

I'm using web service to connect remotly to sugarcrm of different server.(with SoapSugarUsers methods), I counld to use it well but when updating...
In a separate php page I get two variable. two variable must compare with a query in users table
in sugarcrm database. if it can find the record, I want to update this record, for example status change to 'Active' value. I think I should use of set_entry , but instead of updating the record, it inserts a new record with 'Active' value in state field. what do you think? I know I'm in mistake to use set_entry and 'query' !
but how I can update?


//
// Get REQUEST variables
//
$un = $_REQUEST['un'];
$sc = $_REQUEST['sc'];


$user = array(
'session' => '1',
'module_name' => 'Users',
'query' => 'users.email1 = "' . $un . '" and users.his_code="'.$sc.'"',
'name_value_list' => array(
array('name'=>"status",'value'=>'Active'),
)
);
///////// seems to insert a new record, no update!
$user_list_array = $soapclient->call('set_entry',$user);


thanks in advance:,
shahrzad

[shahrzad]

$user_list_params = array(
'session' => '1',
'module_name' => 'Users',
'query' => 'users.email1 = "' . $un . '" and users.his_code="'.$sc.'"',
'offset' => 0,
'select_fields' => array('id'),
'max_results' => 1,
'deleted' => 0
);
$user_list_array = $soapclient->call('get_entry_list',$user_list_params);

$user_id = $user_list_array['entry_list'][0]['name_value_list'][0]['value'];
$user = array(
'session' => '1',
'module_name' => 'Users',
'name_value_list' => array(
array('name'=>"id",'value'=>$user_id),
array('name'=>"status",'value'=>'Active'),
)
);
$user_list_array = $soapclient->call('set_entry',$user);



it works,