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
(Go) Xero Export Accounts to CSVDemonstrates how to export Accounts data to a CSV. Note: Requires Chilkat v9.5.0.64 or greater.
// 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 := chilkat.NewRest() var success bool // 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 := chilkat.NewStringBuilder() success = rest.FullRequestNoBodySb("GET","/api.xro/2.0/Accounts",sbXml) if success != true { fmt.Println(rest.LastErrorText()) rest.DisposeRest() sbXml.DisposeStringBuilder() return } // A 200 response is expected for actual success. if rest.ResponseStatusCode() != 200 { fmt.Println(*sbXml.GetAsString()) rest.DisposeRest() sbXml.DisposeStringBuilder() return } // Build a CSV containing a few Account fields. csv := chilkat.NewCsv() csv.SetHasColumnNames(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 := chilkat.NewXml() xml.LoadSb(sbXml,bAutoTrim) numAccounts := xml.NumChildrenAt("Accounts") i := 0 for i < numAccounts { xml.SetI(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. fmt.Println(*csv.SaveToString()) // Save the CSV to a file. csv.SaveFile("qa_output/xero_accounts.csv") rest.DisposeRest() sbXml.DisposeStringBuilder() csv.DisposeCsv() xml.DisposeXml() |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.