Pascal (Lazarus/Delphi)

SugarCRM Create a Record List

See more SugarCRM Examples

Create a record list in Sugar consisting of a set of ids. Pascal (Lazarus/Delphi)

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.StringBuilder,
  Chilkat.Rest,
  Chilkat.JsonObject;

// ---------------------------------------------------------------------------

procedure RunDemo;
var
  success: Boolean;
  rest: TRest;
  jsonReq: TJsonObject;
  sbReq: TStringBuilder;
  sbJson: TStringBuilder;
  json: TJsonObject;
  id: string;
  assigned_user_id: string;
  module_name: string;
  date_modified: string;
  i: Integer;
  count_i: Integer;
  strVal: string;

begin
  success := False;

  rest := TRest.Create;

  success := rest.Connect('your.site.domain',443,True,True);
  if (success <> True) then
    begin
      WriteLn(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 := TJsonObject.Create;
  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 := TStringBuilder.Create;
  jsonReq.EmitSb(sbReq);

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

  sbJson := TStringBuilder.Create;
  success := rest.FullRequestSb('POST','/rest/v10/Accounts/record_list',sbReq,sbJson);
  if (success <> True) then
    begin
      WriteLn(rest.LastErrorText);
      Exit;
    end;

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

  json := TJsonObject.Create;
  json.LoadSb(sbJson);

  //  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"
  //  }

  WriteLn('Example Completed.');


  rest.Free;
  jsonReq.Free;
  sbReq.Free;
  sbJson.Free;
  json.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.