Chilkat HOME .NET Core C# Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi ActiveX Delphi DLL Go Java Lianja Mono C# Node.js Objective-C PHP ActiveX PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(Chilkat2-Python) Xero Export Accounts to CSVDemonstrates how to export Accounts data to a CSV. Note: Requires Chilkat v9.5.0.64 or greater.
import sys import chilkat2 # Note: Requires Chilkat v9.5.0.64 or greater. # This requires the Chilkat API to have been previously unlocked. # See Global Unlock Sample for sample code. rest = chilkat2.Rest() # Before sending REST API calls, the REST object needs to be # initialized for OAuth1. # See Xero 2-Legged OAuth1 Setup for sample code. # Assuming the REST object's OAuth1 authenticator is setup, and the initial # connection was made, we may now send REST HTTP requests.. # Get the full list of accounts. sbXml = chilkat2.StringBuilder() success = rest.FullRequestNoBodySb("GET","/api.xro/2.0/Accounts",sbXml) if (success != True): print(rest.LastErrorText) sys.exit() # A 200 response is expected for actual success. if (rest.ResponseStatusCode != 200): print(sbXml.GetAsString()) sys.exit() # Build a CSV containing a few Account fields. csv = chilkat2.Csv() csv.HasColumnNames = True csv.SetColumnName(0,"AccountID") csv.SetColumnName(1,"Name") csv.SetColumnName(2,"Code") csv.SetColumnName(3,"EnablePaymentsToAccount") # Iterate over the accounts and build the CSV. bAutoTrim = False xml = chilkat2.Xml() xml.LoadSb(sbXml,bAutoTrim) numAccounts = xml.NumChildrenAt("Accounts") i = 0 while i < numAccounts : xml.I = i csv.SetCellByName(i,"AccountID",xml.GetChildContent("Accounts|Account[i]|AccountID")) csv.SetCellByName(i,"Name",xml.GetChildContent("Accounts|Account[i]|Name")) csv.SetCellByName(i,"Code",xml.GetChildContent("Accounts|Account[i]|Code")) csv.SetCellByName(i,"EnablePaymentsToAccount",xml.GetChildContent("Accounts|Account[i]|EnablePaymentsToAccount")) i = i + 1 # Examine the CSV. print(csv.SaveToString()) # Save the CSV to a file. csv.SaveFile("qa_output/xero_accounts.csv") |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.