Java

SugarCRM Filtering Records

See more SugarCRM Examples

Export records and filter. Chilkat2 Java

import com.chilkatsoft.chilkat2.ChilkatException;
import com.chilkatsoft.chilkat2.JsonObject;
import com.chilkatsoft.chilkat2.Rest;
import com.chilkatsoft.chilkat2.StringBuilder;

public class ChilkatExample {

    public static void main(String[] args) {
        Rest rest = new Rest();

        try {
            rest.connect("your.site.domain", 443, true, true);
        } catch (ChilkatException e) {
            System.out.println(e.getLastErrorText());
            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.
        JsonObject jsonReq = new 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
        // }

        StringBuilder sbReq = new StringBuilder();
        jsonReq.emitSb(sbReq);

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

        StringBuilder sbJson = new StringBuilder();
        try {
            rest.fullRequestSb("POST", "/rest/v10/Accounts/filter", sbReq, sbJson);
        } catch (ChilkatException e) {
            System.out.println(e.getLastErrorText());
            return;
        }

        if (rest.getResponseStatusCode() != 200) {
            System.out.println("Received error response code: " + rest.getResponseStatusCode());
            System.out.println("Response body:");
            System.out.println(sbJson.getAsString());
            return;
        }

        JsonObject json = new JsonObject();
        json.loadSb(sbJson);

        // The following code parses the JSON response.
        // A sample JSON response is shown below the sample code.
        String id = "";
        String date_modified = "";
        String v_module = "";

        int next_offset = json.intOf("next_offset");
        int i = 0;
        int count_i = json.sizeOfArray("records");
        while (i < count_i) {
            json.setI(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"
        //     }
        //   ]
        // }

        System.out.println("Example Completed.");
    }
}