UPDATE A FIELD IN ACCOUNTS USING REST API WITHOUT USING ACCOUNT ID

Hi Anand,

Just changing the $record_arguments array in the example like below should do your job.

$record_arguments = array(
   "account_number" => "{YOUR_UNIQUE_ACCOUNT_NUMBER}",
);

Hope it helps!

-Shijin Krishna

Hi Shijin Krishna

    Thank You for your reply.It worked for me as you said when i have mentioned the account id of the record in

$url = $base_url . "/Accounts860d4d45-2e5a-e211-a5bb-560cf4c7efa3/";

Actually i wanted this to update the record without passing the account id(860d4d45-2e5a-e211-a5bb-560cf4c7efa3) to variable $url as i dont have access to retreive the account id.

I have finally got this by using the filter api and retreiving the account id of the record based on the account number.Then i have passed account id to $url and updated other field in the account.

$filter_arguments = array(

    "filter" => array(

    array(

        'acc_no_c' => 'XXXXXXXX',

    ),

                    ),

);

$url = $base_url . "/Accounts/filter";

$filter_response = call($url, $oauth2_token_response->access_token, 'POST', $filter_arguments);//$filter_response has the account id here and passed it to the $url later and then updated the other fields in the record as per the update api.

Hi Shijin Krishna

    Thank You for your reply.It worked for me as you said when i have mentioned the account id of the record in

$url = $base_url . "/Accounts860d4d45-2e5a-e211-a5bb-560cf4c7efa3/";

Actually i wanted this to update the record without passing the account id(860d4d45-2e5a-e211-a5bb-560cf4c7efa3) to variable $url as i dont have access to retreive the account id.

I have finally got this by using the filter api and retreiving the account id of the record based on the account number.Then i have passed account id to $url and updated other field in the account.

$filter_arguments = array(

    "filter" => array(

    array(

        'acc_no_c' => 'XXXXXXXX',

    ),

                    ),

);

$url = $base_url . "/Accounts/filter";

$filter_response = call($url, $oauth2_token_response->access_token, 'POST', $filter_arguments);//$filter_response has the account id here and passed it to the $url later and then updated the other fields in the record as per the update api.

Hi Anand,

Yes, to update a particular record you should pass the id in url!

Good to hear that you made it work.

Hi Anand,

I am also having the same problem.. Could you please guide me where exactly to place this code as I am new to SugarCRM.