Pascal (Lazarus/Delphi)

QuickBooks - Query Employees

See more QuickBooks Examples

Demonstrates how to query the QuickBooks employee data. 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.StringTable,
  Chilkat.CkDateTime,
  Chilkat.DtObj,
  Chilkat.Rest,
  Chilkat.JsonObject,
  Chilkat.StringBuilder;

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

procedure RunDemo;
var
  success: Boolean;
  jsonToken: TJsonObject;
  rest: TRest;
  bAutoReconnect: Boolean;
  sbAuth: TStringBuilder;
  query: string;
  responseBody: string;
  json: TJsonObject;
  dtime: TCkDateTime;
  bLocalTime: Boolean;
  dt: TDtObj;
  numRecords: Integer;
  i: Integer;
  sTab: TStringTable;
  year: string;
  month: string;
  day: string;

begin
  success := False;

  //  This example assumes the Chilkat API to have been previously unlocked.
  //  See Global Unlock Sample for sample code.

  //  Get our previously obtained OAuth2 access token, which should contain JSON like this:
  //  {
  //    "expires_in": 3600,
  //    "x_refresh_token_expires_in": 8726400,
  //    "refresh_token": "L011546037639r ... 3vR2DrbOmg0Sdagw",
  //    "access_token": "eyJlbmMiOiJBMTI4Q0 ... oETJEMbeggg",
  //    "token_type": "bearer"
  //  }

  jsonToken := TJsonObject.Create;
  success := jsonToken.LoadFile('qa_data/tokens/qb-access-token.json');

  rest := TRest.Create;

  //  Connect using TLS.
  //  A single REST object, once connected, can be used for many Quickbooks REST API calls.
  //  The auto-reconnect indicates that if the already-established HTTPS connection is closed,
  //  then it will be automatically re-established as needed.
  bAutoReconnect := True;
  success := rest.Connect('sandbox-quickbooks.api.intuit.com',443,True,bAutoReconnect);
  if (success = False) then
    begin
      WriteLn(rest.LastErrorText);
      Exit;
    end;

  sbAuth := TStringBuilder.Create;
  sbAuth.Append('Bearer ');
  sbAuth.Append(jsonToken.StringOf('access_token'));
  rest.Authorization := sbAuth.GetAsString();

  rest.AddHeader('Accept','application/json');
  rest.AllowHeaderFolding := False;

  query := 'select * from Employee';
  rest.AddQueryParam('query',query);
  rest.AddQueryParam('minorversion','45');

  //  The company ID is 123146096291789
  responseBody := rest.FullRequestNoBody('GET','/v3/company/123146096291789/query');
  if (rest.LastMethodSuccess = False) then
    begin
      WriteLn(rest.LastErrorText);
      Exit;
    end;

  //  We should expect a 200 response if successful.
  if (rest.ResponseStatusCode <> 200) then
    begin
      WriteLn('Request Header: ');
      WriteLn(rest.LastRequestHeader);
      WriteLn('----');
      WriteLn('Response StatusCode = ' + rest.ResponseStatusCode);
      WriteLn('Response StatusLine: ' + rest.ResponseStatusText);
      WriteLn('Response Header:');
      WriteLn(rest.ResponseHeader);
      WriteLn(responseBody);
      Exit;
    end;

  //  Load the JSON response into a JSON object for parsing.
  //  A sample JSON response is shown below.
  json := TJsonObject.Create;
  json.Load(responseBody);

  //  Show the full JSON response.
  json.EmitCompact := False;
  WriteLn(json.Emit());

  //  Use this online tool to generate parsing code from sample JSON: 
  //  Generate Parsing Code from JSON

  //  These will be used for parsing date/time strings..
  dtime := TCkDateTime.Create;
  bLocalTime := True;
  dt := TDtObj.Create;

  //  Iterate over each account returned.
  numRecords := json.SizeOfArray('QueryResponse.Employee');
  i := 0;
  while i < numRecords do
    begin

      json.I := i;
      WriteLn('DisplayName: ' + json.StringOf('QueryResponse.Employee[i].DisplayName'));
      WriteLn('Id: ' + json.StringOf('QueryResponse.Employee[i].Id'));
      WriteLn('Active: ' + json.BoolOf('QueryResponse.Employee[i].Active'));

      //  Load the CreateTime into a CkDateTime...
      dtime.SetFromTimestamp(json.StringOf('QueryResponse.Employee[i].MetaData.CreateTime'));
      dtime.ToDtObj(bLocalTime,dt);

      WriteLn(dt.Month + '/' + dt.Day + '/' + dt.Year + '  ' + dt.Hour + ':' + dt.Minute);

      //  The the birth year, month, and day, if it exists.
      //  The BirthDate contains something like this: "1985-09-11"
      if (json.HasMember('QueryResponse.Employee[i].BirthDate') = True) then
        begin
          sTab := TStringTable.Create;
          sTab.SplitAndAppend(json.StringOf('QueryResponse.Employee[i].BirthDate'),'-',True,True);
          year := sTab.StringAt(0);
          month := sTab.StringAt(1);
          day := sTab.StringAt(2);
          WriteLn('BirthDate: ' + month + '/' + day + '/' + year);
        end;

      WriteLn('----');
      i := i + 1;
    end;

  WriteLn('Success.');

  //  ------------------------------------------------------
  //  The JSON response looks like this:

  //  {
  //    "QueryResponse": {
  //      "Employee": [
  //        {
  //          "BillableTime": false,
  //          "domain": "QBO",
  //          "sparse": false,
  //          "Id": "55",
  //          "SyncToken": "0",
  //          "MetaData": {
  //            "CreateTime": "2016-09-15T11:21:48-07:00",
  //            "LastUpdatedTime": "2016-09-15T11:21:48-07:00"
  //          },
  //          "GivenName": "Emily",
  //          "FamilyName": "Platt",
  //          "DisplayName": "Emily Platt",
  //          "PrintOnCheckName": "Emily Platt",
  //          "Active": true
  //        },
  //        {
  //          "BillableTime": false,
  //          "BirthDate": "1985-09-11",
  //          "HiredDate": "2016-08-17",
  //          "domain": "QBO",
  //          "sparse": false,
  //          "Id": "54",
  //          "SyncToken": "1",
  //          "MetaData": {
  //            "CreateTime": "2016-09-15T11:21:28-07:00",
  //            "LastUpdatedTime": "2016-09-15T11:46:26-07:00"
  //          },
  //          "GivenName": "John",
  //          "FamilyName": "Johnson",
  //          "DisplayName": "John Johnson",
  //          "PrintOnCheckName": "John Johnson",
  //          "Active": true,
  //          "PrimaryPhone": {
  //            "FreeFormNumber": "(540) 555-9645"
  //          }
  //        },
  //        {
  //          "SSN": "XXX-XX-XXXX",
  //          "PrimaryAddr": {
  //            "Id": "98",
  //            "Line1": "45 N. Elm Street",
  //            "City": "Middlefield",
  //            "CountrySubDivisionCode": "CA",
  //            "PostalCode": "93242"
  //          },
  //          "BillableTime": false,
  //          "domain": "QBO",
  //          "sparse": false,
  //          "Id": "60",
  //          "SyncToken": "0",
  //          "MetaData": {
  //            "CreateTime": "2016-10-25T14:08:18-07:00",
  //            "LastUpdatedTime": "2016-10-25T14:08:18-07:00"
  //          },
  //          "GivenName": "John",
  //          "FamilyName": "Meuller",
  //          "DisplayName": "John Meuller",
  //          "PrintOnCheckName": "John Meuller",
  //          "Active": true,
  //          "PrimaryPhone": {
  //            "FreeFormNumber": "408-525-1234"
  //          }
  //        }
  //      ],
  //      "startPosition": 1,
  //      "maxResults": 3
  //    },
  //    "time": "2016-10-25T14:18:38.487-07:00"
  //  }


  jsonToken.Free;
  rest.Free;
  sbAuth.Free;
  json.Free;
  dtime.Free;
  dt.Free;
          sTab.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.