(Tcl) Xero Get Accounts

See more Xero Examples

Download Xero accounts information

For more information, see https://developer.xero.com/documentation/api/accounts

Chilkat Tcl Extension Downloads Chilkat Tcl Extension Downloads

load ./chilkat.dll

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

set http [new_CkHttp]

set jsonToken [new_CkJsonObject]

set success [CkJsonObject_LoadFile $jsonToken "qa_data/tokens/xero-access-token.json"]
if {$success == 0} then {
    puts [CkJsonObject_lastErrorText $jsonToken]
    delete_CkHttp $http
    delete_CkJsonObject $jsonToken
    exit
}

CkHttp_put_AuthToken $http [CkJsonObject_stringOf $jsonToken "access_token"]

# Replace the value here with an actual tenant ID obtained from this example:
# Get Xero Tenant IDs
CkHttp_SetRequestHeader $http "Xero-tenant-id" "83299b9e-5747-4a14-a18a-a6c94f824eb7"

CkHttp_put_Accept $http "application/json"

# resp is a CkHttpResponse
set resp [CkHttp_QuickRequest $http "GET" "https://api.xero.com/api.xro/2.0/Accounts"]
if {[CkHttp_get_LastMethodSuccess $http] != 1} then {
    puts [CkHttp_lastErrorText $http]
    delete_CkHttp $http
    delete_CkJsonObject $jsonToken
    exit
}

puts "Response Status Code: [CkHttpResponse_get_StatusCode $resp]"

set jsonResponse [new_CkJsonObject]

CkJsonObject_Load $jsonResponse [CkHttpResponse_bodyStr $resp]
CkJsonObject_put_EmitCompact $jsonResponse 0
puts [CkJsonObject_emit $jsonResponse]

if {[CkHttpResponse_get_StatusCode $resp] != 200} then {
    puts "Failed."
    delete_CkHttpResponse $resp

    delete_CkHttp $http
    delete_CkJsonObject $jsonToken
    delete_CkJsonObject $jsonResponse
    exit
}

delete_CkHttpResponse $resp

# 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
#     }
#   ]
# }
# 

set i 0
set count_i [CkJsonObject_SizeOfArray $jsonResponse "Accounts"]
while {$i < $count_i} {
    CkJsonObject_put_I $jsonResponse $i
    set AccountID [CkJsonObject_stringOf $jsonResponse "Accounts[i].AccountID"]
    set Code [CkJsonObject_stringOf $jsonResponse "Accounts[i].Code"]
    set Name [CkJsonObject_stringOf $jsonResponse "Accounts[i].Name"]
    set Type [CkJsonObject_stringOf $jsonResponse "Accounts[i].Type"]
    set TaxType [CkJsonObject_stringOf $jsonResponse "Accounts[i].TaxType"]
    set EnablePaymentsToAccount [CkJsonObject_BoolOf $jsonResponse "Accounts[i].EnablePaymentsToAccount"]
    set BankAccountNumber [CkJsonObject_stringOf $jsonResponse "Accounts[i].BankAccountNumber"]
    set BankAccountType [CkJsonObject_stringOf $jsonResponse "Accounts[i].BankAccountType"]
    set CurrencyCode [CkJsonObject_stringOf $jsonResponse "Accounts[i].CurrencyCode"]
    set Description [CkJsonObject_stringOf $jsonResponse "Accounts[i].Description"]
    set i [expr $i + 1]
}

delete_CkHttp $http
delete_CkJsonObject $jsonToken
delete_CkJsonObject $jsonResponse