Chilkat HOME .NET Core C# Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi ActiveX Delphi DLL Go Java Lianja Mono C# Node.js Objective-C PHP ActiveX PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(Java) SugarCRM Filtering RecordsExport records and filter.
import com.chilkatsoft.*; public class ChilkatExample { static { try { System.loadLibrary("chilkat"); } catch (UnsatisfiedLinkError e) { System.err.println("Native code library failed to load.\n" + e); System.exit(1); } } public static void main(String argv[]) { CkRest rest = new CkRest(); boolean success; success = rest.Connect("your.site.domain",443,true,true); if (success != true) { System.out.println(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. CkJsonObject jsonReq = new CkJsonObject(); 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 // } CkStringBuilder sbReq = new CkStringBuilder(); jsonReq.EmitSb(sbReq); rest.AddHeader("Content-Type","application/json"); CkStringBuilder sbJson = new CkStringBuilder(); success = rest.FullRequestSb("POST","/rest/v10/Accounts/filter",sbReq,sbJson); if (success != true) { System.out.println(rest.lastErrorText()); return; } if (rest.get_ResponseStatusCode() != 200) { System.out.println("Received error response code: " + rest.get_ResponseStatusCode()); System.out.println("Response body:"); System.out.println(sbJson.getAsString()); return; } CkJsonObject json = new CkJsonObject(); 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.put_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" // } // ] // } System.out.println("Example Completed."); } } |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.