Chilkat HOME Android™ Classic ASP C C++ C# Mono C# .NET Core C# C# UWP/WinRT DataFlex Delphi ActiveX Delphi DLL Visual FoxPro Java Lianja MFC Objective-C Perl PHP ActiveX PHP Extension PowerBuilder PowerShell PureBasic CkPython Chilkat2-Python Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ Visual Basic 6.0 VB.NET VB.NET UWP/WinRT VBScript Xojo Plugin Node.js Excel Go
(MFC) 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) { CkString strOut; // 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) { strOut.append(rest.lastErrorText()); strOut.append("\r\n"); SetDlgItemText(IDC_EDIT1,strOut.getUnicode()); return; } // A 200 response is expected for actual success. if (rest.get_ResponseStatusCode() != 200) { strOut.append(sbXml.getAsString()); strOut.append("\r\n"); SetDlgItemText(IDC_EDIT1,strOut.getUnicode()); 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. strOut.append(csv.saveToString()); strOut.append("\r\n"); // Save the CSV to a file. csv.SaveFile("qa_output/xero_accounts.csv"); SetDlgItemText(IDC_EDIT1,strOut.getUnicode()); } |
© 2000-2022 Chilkat Software, Inc. All Rights Reserved.