(Node.js) SugarCRM Filtering Records

Export records and filter.

Install Chilkat for Node.js and Electron using npm at Chilkat npm packages for Node.js Chilkat npm packages for Electron on Windows, Linux, MacOSX, and ARM

var os = require('os');
if (os.platform() == 'win32') {  
    if (os.arch() == 'ia32') {
        var chilkat = require('@chilkat/ck-node21-win-ia32');
    } else {
        var chilkat = require('@chilkat/ck-node21-win64'); 
    }
} else if (os.platform() == 'linux') {
    if (os.arch() == 'arm') {
        var chilkat = require('@chilkat/ck-node21-arm');
    } else if (os.arch() == 'x86') {
        var chilkat = require('@chilkat/ck-node21-linux32');
    } else {
        var chilkat = require('@chilkat/ck-node21-linux64');
    }
} else if (os.platform() == 'darwin') {
    if (os.arch() == 'arm64') {
        var chilkat = require('@chilkat/ck-node21-mac-m1');
    } else {
        var chilkat = require('@chilkat/ck-node21-macosx');
    }
}

function chilkatExample() {

    var rest = new chilkat.Rest();
    var success;

    success = rest.Connect("your.site.domain",443,true,true);
    if (success !== true) {
        console.log(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.
    var 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
    // }

    var sbReq = new chilkat.StringBuilder();
    jsonReq.EmitSb(sbReq);

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

    var sbJson = new chilkat.StringBuilder();
    success = rest.FullRequestSb("POST","/rest/v10/Accounts/filter",sbReq,sbJson);
    if (success !== true) {
        console.log(rest.LastErrorText);
        return;
    }

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

    var json = new chilkat.JsonObject();
    json.LoadSb(sbJson);

    // The following code parses the JSON response.
    // A sample JSON response is shown below the sample code.
    var next_offset;
    var i;
    var count_i;
    var id;
    var date_modified;
    var 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"
    //     }
    //   ]
    // }

    console.log("Example Completed.");

}

chilkatExample();