Pascal (Lazarus/Delphi)

SugarCRM Filtering Records

See more SugarCRM Examples

Export records and filter. 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;
  next_offset: Integer;
  i: Integer;
  count_i: Integer;
  id: string;
  date_modified: string;
  v_module: 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('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
  //  }

  sbReq := TStringBuilder.Create;
  jsonReq.EmitSb(sbReq);

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

  sbJson := TStringBuilder.Create;
  success := rest.FullRequestSb('POST','/rest/v10/Accounts/filter',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.

  next_offset := json.IntOf('next_offset');
  i := 0;
  count_i := json.SizeOfArray('records');
  while i < count_i do
    begin
      json.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;
    end;

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

  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.