Pascal (Lazarus/Delphi)
/:record endpoint. In this example we get an Account record by it's ID, but only request the Name, Email, and Industry fields.
Pascal (Lazarus/Delphi)
SugarCRM Getting a Record
See more SugarCRM Examples
Gets a record from the Sugar instance using the /Chilkat Pascal (Lazarus/Delphi) Downloads
program ChilkatDemo;
// Demonstrates using the Chilkat Pascal wrapper via the C bridge DLL.
// Builds as a console application under Lazarus (FPC) or Delphi.
{$IFDEF FPC}
{$MODE DELPHI}
{$ENDIF}
{$APPTYPE CONSOLE}
uses
{$IFDEF UNIX}
cthreads,
{$ENDIF}
SysUtils,
CkDllLoader,
Chilkat.Http,
Chilkat.StringBuilder,
Chilkat.JsonObject;
// ---------------------------------------------------------------------------
procedure RunDemo;
var
success: Boolean;
http: THttp;
sbResponseBody: TStringBuilder;
jResp: TJsonObject;
respStatusCode: Integer;
id: string;
name: string;
date_modified: string;
industry: string;
email1: string;
v_module: string;
begin
success := False;
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
http := THttp.Create;
// Implements the following CURL command:
// curl -H OAuth-Token:<access_token> -H Cache-Control:no-cache http://<site_url>/rest/v10/Accounts/<record_id>?fields=name,email1,industry
http.SetRequestHeader('Cache-Control','no-cache');
http.SetRequestHeader('OAuth-Token','<access_token>');
sbResponseBody := TStringBuilder.Create;
success := http.QuickGetSb('http://<site_url>/rest/v10/Accounts/<record_id>?fields=name,email1,industry',sbResponseBody);
if (success = False) then
begin
WriteLn(http.LastErrorText);
Exit;
end;
jResp := TJsonObject.Create;
jResp.LoadSb(sbResponseBody);
jResp.EmitCompact := False;
WriteLn('Response Body:');
WriteLn(jResp.Emit());
respStatusCode := http.LastStatus;
WriteLn('Response Status Code = ' + respStatusCode);
if (respStatusCode >= 400) then
begin
WriteLn('Response Header:');
WriteLn(http.LastHeader);
WriteLn('Failed.');
Exit;
end;
// Sample JSON response:
// (Sample code for parsing the JSON response is shown below)
// {
// "id": "ab2222df-73da-0e92-6887-5705428f4d68",
// "name": "Test Record",
// "date_modified": "2016-04-06T15:03:21-04:00",
// "industry": "",
// "email1": "test@sugar.com",
// "_acl": {
// "fields": {}
// },
// "_module": "Accounts"
// }
// Sample code for parsing the JSON response...
// Use the following online tool to generate parsing code from sample JSON:
// Generate Parsing Code from JSON
id := jResp.StringOf('id');
name := jResp.StringOf('name');
date_modified := jResp.StringOf('date_modified');
industry := jResp.StringOf('industry');
email1 := jResp.StringOf('email1');
v_module := jResp.StringOf('_module');
http.Free;
sbResponseBody.Free;
jResp.Free;
end;
// ---------------------------------------------------------------------------
begin
try
RunDemo;
except
on E: Exception do
WriteLn('Unhandled exception: ', E.ClassName, ': ', E.Message);
end;
WriteLn;
{$IFDEF MSWINDOWS}
WriteLn('Press Enter to exit...');
ReadLn;
{$ENDIF}
end.