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
(Unicode C++) Xero Export Accounts to CSVDemonstrates how to export Accounts data to a CSV. Note: Requires Chilkat v9.5.0.64 or greater.
#include <CkRestW.h> #include <CkStringBuilderW.h> #include <CkCsvW.h> #include <CkXmlW.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. CkRestW 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. CkStringBuilderW sbXml; success = rest.FullRequestNoBodySb(L"GET",L"/api.xro/2.0/Accounts",sbXml); if (success != true) { wprintf(L"%s\n",rest.lastErrorText()); return; } // A 200 response is expected for actual success. if (rest.get_ResponseStatusCode() != 200) { wprintf(L"%s\n",sbXml.getAsString()); return; } // Build a CSV containing a few Account fields. CkCsvW csv; csv.put_HasColumnNames(true); csv.SetColumnName(0,L"AccountID"); csv.SetColumnName(1,L"Name"); csv.SetColumnName(2,L"Code"); csv.SetColumnName(3,L"EnablePaymentsToAccount"); // Iterate over the accounts and build the CSV. bool bAutoTrim = false; CkXmlW xml; xml.LoadSb(sbXml,bAutoTrim); int numAccounts = xml.NumChildrenAt(L"Accounts"); int i = 0; while (i < numAccounts) { xml.put_I(i); csv.SetCellByName(i,L"AccountID",xml.getChildContent(L"Accounts|Account[i]|AccountID")); csv.SetCellByName(i,L"Name",xml.getChildContent(L"Accounts|Account[i]|Name")); csv.SetCellByName(i,L"Code",xml.getChildContent(L"Accounts|Account[i]|Code")); csv.SetCellByName(i,L"EnablePaymentsToAccount",xml.getChildContent(L"Accounts|Account[i]|EnablePaymentsToAccount")); i = i + 1; } // Examine the CSV. wprintf(L"%s\n",csv.saveToString()); // Save the CSV to a file. csv.SaveFile(L"qa_output/xero_accounts.csv"); } |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.