Delphi ActiveX

Xero Get Accounts

See more Xero Examples

Download Xero accounts information 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;
http: TChilkatHttp;
jsonToken: TChilkatJsonObject;
resp: TChilkatHttpResponse;
jsonResponse: TChilkatJsonObject;
AccountID: WideString;
Code: WideString;
Name: WideString;
Type: WideString;
TaxType: WideString;
EnablePaymentsToAccount: Integer;
BankAccountNumber: WideString;
BankAccountType: WideString;
CurrencyCode: WideString;
Description: WideString;
i: Integer;
count_i: Integer;

begin
success := 0;

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

http := TChilkatHttp.Create(Self);

jsonToken := TChilkatJsonObject.Create(Self);
success := jsonToken.LoadFile('qa_data/tokens/xero-access-token.json');
if (success = 0) then
  begin
    Memo1.Lines.Add(jsonToken.LastErrorText);
    Exit;
  end;

http.AuthToken := jsonToken.StringOf('access_token');

// Replace the value here with an actual tenant ID obtained from this example:
// Get Xero Tenant IDs
http.SetRequestHeader('Xero-tenant-id','83299b9e-5747-4a14-a18a-a6c94f824eb7');

http.Accept := 'application/json';

resp := TChilkatHttpResponse.Create(Self);
success := http.HttpNoBody('GET','https://api.xero.com/api.xro/2.0/Accounts',resp.ControlInterface);
if (success = 0) then
  begin
    Memo1.Lines.Add(http.LastErrorText);
    Exit;
  end;

Memo1.Lines.Add('Response Status Code: ' + IntToStr(resp.StatusCode));

jsonResponse := TChilkatJsonObject.Create(Self);
jsonResponse.Load(resp.BodyStr);
jsonResponse.EmitCompact := 0;
Memo1.Lines.Add(jsonResponse.Emit());

if (resp.StatusCode <> 200) then
  begin
    Memo1.Lines.Add('Failed.');
    Exit;
  end;

// Sample output...
// (See the parsing code below..)
// 
// Use the this online tool to generate parsing code from sample JSON: 
// Generate Parsing Code from JSON

// {
//   "Accounts": [
//     {
//       "AccountID": "ebd06280-af70-4bed-97c6-7451a454ad85",
//       "Code": "091",
//       "Name": "Business Savings Account",
//       "Type": "BANK",
//       "TaxType": "NONE",
//       "EnablePaymentsToAccount": false,
//       "BankAccountNumber": "0209087654321050",
//       "BankAccountType": "BANK",
//       "CurrencyCode": "NZD"
//     },
//     {
//       "AccountID": "7d05a53d-613d-4eb2-a2fc-dcb6adb80b80",
//       "Code": "200",
//       "Name": "Sales",
//       "Type": "REVENUE",
//       "TaxType": "OUTPUT2",
//       "Description": "Income from any normal business activity",
//       "EnablePaymentsToAccount": false
//     }
//   ]
// }
// 

i := 0;
count_i := jsonResponse.SizeOfArray('Accounts');
while i < count_i do
  begin
    jsonResponse.I := i;
    AccountID := jsonResponse.StringOf('Accounts[i].AccountID');
    Code := jsonResponse.StringOf('Accounts[i].Code');
    Name := jsonResponse.StringOf('Accounts[i].Name');
    Type := jsonResponse.StringOf('Accounts[i].Type');
    TaxType := jsonResponse.StringOf('Accounts[i].TaxType');
    EnablePaymentsToAccount := jsonResponse.BoolOf('Accounts[i].EnablePaymentsToAccount');
    BankAccountNumber := jsonResponse.StringOf('Accounts[i].BankAccountNumber');
    BankAccountType := jsonResponse.StringOf('Accounts[i].BankAccountType');
    CurrencyCode := jsonResponse.StringOf('Accounts[i].CurrencyCode');
    Description := jsonResponse.StringOf('Accounts[i].Description');
    i := i + 1;
  end;
end;