Chilkat2-Python
Chilkat2-Python
Xero Get Accounts
See more Xero Examples
Download Xero accounts informationChilkat Chilkat2-Python Downloads
import sys
import chilkat2
success = False
# This example requires the Chilkat API to have been previously unlocked.
# See Global Unlock Sample for sample code.
http = chilkat2.Http()
jsonToken = chilkat2.JsonObject()
success = jsonToken.LoadFile("qa_data/tokens/xero-access-token.json")
if (success == False):
print(jsonToken.LastErrorText)
sys.exit()
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 = chilkat2.HttpResponse()
success = http.HttpNoBody("GET","https://api.xero.com/api.xro/2.0/Accounts",resp)
if (success == False):
print(http.LastErrorText)
sys.exit()
print("Response Status Code: " + str(resp.StatusCode))
jsonResponse = chilkat2.JsonObject()
jsonResponse.Load(resp.BodyStr)
jsonResponse.EmitCompact = False
print(jsonResponse.Emit())
if (resp.StatusCode != 200):
print("Failed.")
sys.exit()
# 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 :
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