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
(VBScript) Xero Export Accounts to CSVDemonstrates how to export Accounts data to a CSV. Note: Requires Chilkat v9.5.0.64 or greater.
Dim fso, outFile Set fso = CreateObject("Scripting.FileSystemObject") Set outFile = fso.CreateTextFile("output.txt", True) ' 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. set rest = CreateObject("Chilkat_9_5_0.Rest") ' 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. set sbXml = CreateObject("Chilkat_9_5_0.StringBuilder") success = rest.FullRequestNoBodySb("GET","/api.xro/2.0/Accounts",sbXml) If (success <> 1) Then outFile.WriteLine(rest.LastErrorText) WScript.Quit End If ' A 200 response is expected for actual success. If (rest.ResponseStatusCode <> 200) Then outFile.WriteLine(sbXml.GetAsString()) WScript.Quit End If ' Build a CSV containing a few Account fields. set csv = CreateObject("Chilkat_9_5_0.Csv") csv.HasColumnNames = 1 success = csv.SetColumnName(0,"AccountID") success = csv.SetColumnName(1,"Name") success = csv.SetColumnName(2,"Code") success = csv.SetColumnName(3,"EnablePaymentsToAccount") ' Iterate over the accounts and build the CSV. bAutoTrim = 0 set xml = CreateObject("Chilkat_9_5_0.Xml") success = xml.LoadSb(sbXml,bAutoTrim) numAccounts = xml.NumChildrenAt("Accounts") i = 0 Do While i < numAccounts xml.I = i success = csv.SetCellByName(i,"AccountID",xml.GetChildContent("Accounts|Account[i]|AccountID")) success = csv.SetCellByName(i,"Name",xml.GetChildContent("Accounts|Account[i]|Name")) success = csv.SetCellByName(i,"Code",xml.GetChildContent("Accounts|Account[i]|Code")) success = csv.SetCellByName(i,"EnablePaymentsToAccount",xml.GetChildContent("Accounts|Account[i]|EnablePaymentsToAccount")) i = i + 1 Loop ' Examine the CSV. outFile.WriteLine(csv.SaveToString()) ' Save the CSV to a file. success = csv.SaveFile("qa_output/xero_accounts.csv") outFile.Close |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.