C#

SugarCRM Filtering Records

See more SugarCRM Examples

Export records and filter. C#

bool success = false;

Chilkat.Rest rest = new Chilkat.Rest();

success = rest.Connect("your.site.domain",443,true,true);
if (success != true) {
    Debug.WriteLine(rest.LastErrorText);
    return;
}

rest.AddHeader("Cache-Control","no-cache");
rest.AddHeader("OAuth-Token","<access_token>");

//  The following code creates the JSON request body.
//  The JSON created by this code is shown below.
Chilkat.JsonObject jsonReq = new Chilkat.JsonObject();
jsonReq.UpdateString("filter[0].$or[0].name.$starts","A");
jsonReq.UpdateString("filter[0].$or[1].name.$starts","b");
jsonReq.UpdateNumber("max_num","2");
jsonReq.UpdateNumber("offset","0");
jsonReq.UpdateString("fields","id");
jsonReq.UpdateString("order_by","date_entered");
jsonReq.UpdateBool("favorites",false);
jsonReq.UpdateBool("my_items",false);

//  The JSON request body created by the above code:

//  {
//    "filter": [
//      {
//        "$or": [
//          {
//            "name": {
//              "$starts": "A"
//            }
//          },
//          {
//            "name": {
//              "$starts": "b"
//            }
//          }
//        ]
//      }
//    ],
//    "max_num": 2,
//    "offset": 0,
//    "fields": "id",
//    "order_by": "date_entered",
//    "favorites": false,
//    "my_items": false
//  }

Chilkat.StringBuilder sbReq = new Chilkat.StringBuilder();
jsonReq.EmitSb(sbReq);

rest.AddHeader("Content-Type","application/json");

Chilkat.StringBuilder sbJson = new Chilkat.StringBuilder();
success = rest.FullRequestSb("POST","/rest/v10/Accounts/filter",sbReq,sbJson);
if (success != true) {
    Debug.WriteLine(rest.LastErrorText);
    return;
}

if (rest.ResponseStatusCode != 200) {
    Debug.WriteLine("Received error response code: " + Convert.ToString(rest.ResponseStatusCode));
    Debug.WriteLine("Response body:");
    Debug.WriteLine(sbJson.GetAsString());
    return;
}

Chilkat.JsonObject json = new Chilkat.JsonObject();
json.LoadSb(sbJson);

//  The following code parses the JSON response.
//  A sample JSON response is shown below the sample code.
int next_offset;
int i;
int count_i;
string id;
string date_modified;
string v_module;

next_offset = json.IntOf("next_offset");
i = 0;
count_i = json.SizeOfArray("records");
while (i < count_i) {
    json.I = i;
    id = json.StringOf("records[i].id");
    date_modified = json.StringOf("records[i].date_modified");
    v_module = json.StringOf("records[i]._module");
    i = i + 1;
}

//  A sample JSON response body that is parsed by the above code:

//  {
//    "next_offset": 2,
//    "records": [
//      {
//        "id": "f16760a4-3a52-f77d-1522-5703ca28925f",
//        "date_modified": "2016-04-05T10:23:28-04:00",
//        "_acl": {
//          "fields": {}
//        },
//        "_module": "Accounts"
//      },
//      {
//        "id": "ec409fbb-2b22-4f32-7fa1-5703caf78dc3",
//        "date_modified": "2016-04-05T10:23:28-04:00",
//        "_acl": {
//          "fields": {}
//        },
//        "_module": "Accounts"
//      }
//    ]
//  }

Debug.WriteLine("Example Completed.");