Delphi ActiveX

SugarCRM Create a Record List

See more SugarCRM Examples

Create a record list in Sugar consisting of a set of ids. Delphi ActiveX

uses
    Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics,
    Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Vcl.StdCtrls, Chilkat_TLB;

...

procedure TForm1.Button1Click(Sender: TObject);
var
success: Integer;
rest: TChilkatRest;
jsonReq: TChilkatJsonObject;
sbReq: TChilkatStringBuilder;
sbJson: TChilkatStringBuilder;
json: TChilkatJsonObject;
id: WideString;
assigned_user_id: WideString;
module_name: WideString;
date_modified: WideString;
i: Integer;
count_i: Integer;
strVal: WideString;

begin
success := 0;

rest := TChilkatRest.Create(Self);

success := rest.Connect('your.site.domain',443,1,1);
if (success <> 1) then
  begin
    Memo1.Lines.Add(rest.LastErrorText);
    Exit;
  end;

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.
jsonReq := TChilkatJsonObject.Create(Self);
jsonReq.UpdateString('records[0]','f16760a4-3a52-f77d-1522-5703ca28925f');
jsonReq.UpdateString('records[1]','ec409fbb-2b22-4f32-7fa1-5703caf78dc3');

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

// {
//   "records": [
//     "f16760a4-3a52-f77d-1522-5703ca28925f",
//     "ec409fbb-2b22-4f32-7fa1-5703caf78dc3"
//   ]
// }

sbReq := TChilkatStringBuilder.Create(Self);
jsonReq.EmitSb(sbReq.ControlInterface);

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

sbJson := TChilkatStringBuilder.Create(Self);
success := rest.FullRequestSb('POST','/rest/v10/Accounts/record_list',sbReq.ControlInterface,sbJson.ControlInterface);
if (success <> 1) then
  begin
    Memo1.Lines.Add(rest.LastErrorText);
    Exit;
  end;

if (rest.ResponseStatusCode <> 200) then
  begin
    Memo1.Lines.Add('Received error response code: ' + IntToStr(rest.ResponseStatusCode));
    Memo1.Lines.Add('Response body:');
    Memo1.Lines.Add(sbJson.GetAsString());
    Exit;
  end;

json := TChilkatJsonObject.Create(Self);
json.LoadSb(sbJson.ControlInterface);

// The following code parses the JSON response.
// A sample JSON response is shown below the sample code.

id := json.StringOf('id');
assigned_user_id := json.StringOf('assigned_user_id');
module_name := json.StringOf('module_name');
date_modified := json.StringOf('date_modified');
i := 0;
count_i := json.SizeOfArray('records');
while i < count_i do
  begin
    json.I := i;
    strVal := json.StringOf('records[i]');
    i := i + 1;
  end;

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

// {
//   "id": "ef963176-4845-bc55-b03e-570430b4173c",
//   "assigned_user_id": "1",
//   "module_name": "Accounts",
//   "records": [
//     "f16760a4-3a52-f77d-1522-5703ca28925f",
//     "ec409fbb-2b22-4f32-7fa1-5703caf78dc3"
//   ],
//   "date_modified": "2016-04-05 21:39:19"
// }

Memo1.Lines.Add('Example Completed.');
end;