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
(Swift 2) Xero Export Accounts to CSVDemonstrates how to export Accounts data to a CSV. Note: Requires Chilkat v9.5.0.64 or greater.
func chilkatTest() { // 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. let rest = CkoRest() 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. let sbXml = CkoStringBuilder() success = rest.FullRequestNoBodySb("GET", uriPath: "/api.xro/2.0/Accounts", sb: sbXml) if success != true { print("\(rest.LastErrorText)") return } // A 200 response is expected for actual success. if rest.ResponseStatusCode.intValue != 200 { print("\(sbXml.GetAsString())") return } // Build a CSV containing a few Account fields. let csv = CkoCsv() csv.HasColumnNames = true csv.SetColumnName(0, columnName: "AccountID") csv.SetColumnName(1, columnName: "Name") csv.SetColumnName(2, columnName: "Code") csv.SetColumnName(3, columnName: "EnablePaymentsToAccount") // Iterate over the accounts and build the CSV. var bAutoTrim: Bool = false let xml = CkoXml() xml.LoadSb(sbXml, autoTrim: bAutoTrim) var numAccounts: Int = xml.NumChildrenAt("Accounts").intValue var i: Int = 0 while i < numAccounts { xml.I = i csv.SetCellByName(i, columnName: "AccountID", content: xml.GetChildContent("Accounts|Account[i]|AccountID")) csv.SetCellByName(i, columnName: "Name", content: xml.GetChildContent("Accounts|Account[i]|Name")) csv.SetCellByName(i, columnName: "Code", content: xml.GetChildContent("Accounts|Account[i]|Code")) csv.SetCellByName(i, columnName: "EnablePaymentsToAccount", content: 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.