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
(Classic ASP) 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.
<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> </head> <body> <% ' 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 = Server.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.. ' ------------------------------------------------------------ ' Add the "where" parameter. success = rest.AddQueryParam("where","Type==""SALES""") ' Get the full list of accounts. set sbXml = Server.CreateObject("Chilkat_9_5_0.StringBuilder") success = rest.FullRequestNoBodySb("GET","/api.xro/2.0/Accounts",sbXml) If (success <> 1) Then Response.Write "<pre>" & Server.HTMLEncode( rest.LastErrorText) & "</pre>" Response.End End If ' A 200 response is expected for actual success. If (rest.ResponseStatusCode <> 200) Then Response.Write "<pre>" & Server.HTMLEncode( sbXml.GetAsString()) & "</pre>" Response.End End If ' Iterate over the accounts and get some information.. bAutoTrim = 0 set xml = Server.CreateObject("Chilkat_9_5_0.Xml") success = xml.LoadSb(sbXml,bAutoTrim) ' How many accounts exist? numAccounts = xml.NumChildrenAt("Accounts") Response.Write "<pre>" & Server.HTMLEncode( "numAccounts = " & numAccounts) & "</pre>" i = 0 Do While i < numAccounts xml.I = i Response.Write "<pre>" & Server.HTMLEncode( "AccountID: " & xml.GetChildContent("Accounts|Account[i]|AccountID")) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( "Name: " & xml.GetChildContent("Accounts|Account[i]|Name")) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( "Code: " & xml.GetChildIntValue("Accounts|Account[i]|Code")) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( "EnablePaymentsToAccount: " & xml.GetChildBoolValue("Accounts|Account[i]|EnablePaymentsToAccount")) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( "----") & "</pre>" i = i + 1 Loop %> </body> </html> |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.