how to Filter users based on a particular field?

SugarCRM devs,

Any help on this issue will be much appreciated.

Hi admin guy 

How and where do you try this request?

I just tried in a PHP script and it worked without big deal.

$filter_arguments = array(
   "filter" => array(
      array(
         "user_name" => $user_name,
      ),
   ),
   "max_num" => 5,
   "offset" => 0,
   "fields" => "id,user_name,first_name,last_name",
   "order_by" => "date_entered",
   "favorites" => false,
   "my_items" => false,
);

curl_setopt($request, CURLOPT_POSTFIELDS, json_encode($filter_arguments));

$response = json_decode(curl_exec($request));

Kind regards

Andre, I'm using cURL to execute the API. As mentioned in the original post, I'm using the URL below.

https://nykizq7354.trial.sugarcrm.eu/rest/v10/Users?filter%5B0%5D%5Buser_name%5D%3Dscm-curl2%40blah.com&fields=id,user_name 

curl -iX GET -H "OAuth-Token: XXX" https://nykizq7354.trial.sugarcrm.eu/rest/v10/Users?filter%5B0%5D%5Buser_name%5D%3Dscm-curl3%40blah.com&fields=id,user_name

This gives me zero results. And I'm sure this user exists. When I don't apply any filter and hit /Users, I could see this user.

Did you follow the example from this article?

As per this example and your needs, the request may be something like that:

curl -s -X POST -H OAuth-Token:{access_token} -H Cache-Control:no-cache -d '{      "filter":[         {            "user_name":<user_name>       }    ],    "max_num":2,    "offset":0,    "fields":"id",    "order_by":"date_entered",    "favorites":false,    "my_items":false }' https://{site_url}/rest/v10/Users/filter

Did you follow the example from this article?

As per this example and your needs, the request may be something like that:

curl -s -X POST -H OAuth-Token:{access_token} -H Cache-Control:no-cache -d '{      "filter":[         {            "user_name":<user_name>       }    ],    "max_num":2,    "offset":0,    "fields":"id",    "order_by":"date_entered",    "favorites":false,    "my_items":false }' https://{site_url}/rest/v10/Users/filter

Yes, I did try using POST instead of GET and it resulted in an HTTP 500 Error. I'll post the exact error sent in the response payload tomorrow. Thanks for following up so far.

This is the response I get.

HTTP/1.1 500 Internal Server Error

Bad data passed in; <a href="https://nykizq7354.trial.sugarcrm.eu">Return to Home

The cURL command is below.

curl -iX POST https://nykizq7354.trial.sugarcrm.eu/rest/v10/Users/filter -d '{"filter":[{"user_name":"scm-curl3@blah.com"}]}' -H "OAuth-Token:05b21956-0d58-4529-a9fd-152462d1d3df"

There is definitely something going on here.

At last, this is the URL that worked.

https://nykizq7354.trial.sugarcrm.eu/rest/v10/Users?filter=%5B%7B%22user_name%22:%22scm-curl3@blah.com%2…