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
(Excel) Xero Get a Filtered Set of Resources (Get all SALES Accounts)Demonstrates how to add the "where" parameter to get a filtered set of resources. See Get Filtered Resources. This example gets the accounts where the Type = "SALES". 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. Dim rest As Chilkat.Rest Set rest = Chilkat.NewRest ' 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.. ' ------------------------------------------------------------ ' Add the "where" parameter. success = rest.AddQueryParam("where","Type==""SALES""") ' Get the full list of accounts. Dim sbXml As Chilkat.StringBuilder Set sbXml = Chilkat.NewStringBuilder success = rest.FullRequestNoBodySb("GET","/api.xro/2.0/Accounts",sbXml) If (success <> True) Then Debug.Print rest.LastErrorText Exit Sub End If ' A 200 response is expected for actual success. If (rest.ResponseStatusCode <> 200) Then Debug.Print sbXml.GetAsString() Exit Sub End If ' Iterate over the accounts and get some information.. bAutoTrim = False Dim xml As Chilkat.Xml Set xml = Chilkat.NewXml success = xml.LoadSb(sbXml,bAutoTrim) ' How many accounts exist? numAccounts = xml.NumChildrenAt("Accounts") Debug.Print "numAccounts = "; numAccounts i = 0 Do While i < numAccounts xml.I = i Debug.Print "AccountID: "; xml.GetChildContent("Accounts|Account[i]|AccountID") Debug.Print "Name: "; xml.GetChildContent("Accounts|Account[i]|Name") Debug.Print "Code: "; xml.GetChildIntValue("Accounts|Account[i]|Code") Debug.Print "EnablePaymentsToAccount: "; xml.GetChildBoolValue("Accounts|Account[i]|EnablePaymentsToAccount") Debug.Print "----" i = i + 1 Loop |
© 2000-2022 Chilkat Software, Inc. All Rights Reserved.