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
(.NET Core C#) 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. Chilkat.Rest rest = new Chilkat.Rest(); bool success; // 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. Chilkat.StringBuilder sbXml = new Chilkat.StringBuilder(); success = rest.FullRequestNoBodySb("GET","/api.xro/2.0/Accounts",sbXml); if (success != true) { Debug.WriteLine(rest.LastErrorText); return; } // A 200 response is expected for actual success. if (rest.ResponseStatusCode != 200) { Debug.WriteLine(sbXml.GetAsString()); return; } // Build a CSV containing a few Account fields. Chilkat.Csv csv = new Chilkat.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. bool bAutoTrim = false; Chilkat.Xml xml = new Chilkat.Xml(); xml.LoadSb(sbXml,bAutoTrim); int numAccounts = xml.NumChildrenAt("Accounts"); int 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. Debug.WriteLine(csv.SaveToString()); // Save the CSV to a file. csv.SaveFile("qa_output/xero_accounts.csv"); |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.