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
(C++) Xero Export Accounts to CSVDemonstrates how to export Accounts data to a CSV. Note: Requires Chilkat v9.5.0.64 or greater.
#include <CkRest.h> #include <CkStringBuilder.h> #include <CkCsv.h> #include <CkXml.h> void ChilkatSample(void) { // 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. CkRest 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. CkStringBuilder sbXml; success = rest.FullRequestNoBodySb("GET","/api.xro/2.0/Accounts",sbXml); if (success != true) { std::cout << rest.lastErrorText() << "\r\n"; return; } // A 200 response is expected for actual success. if (rest.get_ResponseStatusCode() != 200) { std::cout << sbXml.getAsString() << "\r\n"; return; } // Build a CSV containing a few Account fields. CkCsv csv; csv.put_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; CkXml xml; xml.LoadSb(sbXml,bAutoTrim); int numAccounts = xml.NumChildrenAt("Accounts"); int i = 0; while (i < numAccounts) { xml.put_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. std::cout << csv.saveToString() << "\r\n"; // Save the CSV to a file. csv.SaveFile("qa_output/xero_accounts.csv"); } |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.