(VBScript) Demonstrate the XML "I" Property

Demonstrates the XML "I" property. The properties I, J, and K can be used in paths to access the I'th, J'th, or K'th child in a path. Three indexing properties are provided to allow for triple-nested loops using this feature.

Note: This example requires Chilkat v9.5.0.64 or later.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

' This example uses the XML document at https://www.chilkatsoft.com/exampleData/xero_accounts.xml
' The data is a download of the Xero accounts for the sandbox company test data (it's not real data).

' We'll use Chilkat HTTP to download the XML.
' This example assumes the Chilkat HTTP API to have been previously unlocked.
' See Global Unlock Sample for sample code.

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder")
set sbXml = CreateObject("Chilkat.StringBuilder")

' Download the XML from https://www.chilkatsoft.com/exampleData/xero_accounts.xml
' into sbXml
url = "https://www.chilkatsoft.com/exampleData/xero_accounts.xml"
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Http")
set http = CreateObject("Chilkat.Http")
success = http.QuickGetSb(url,sbXml)
If (success <> 1) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

bAutoTrim = 0
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Xml")
set xml = CreateObject("Chilkat.Xml")
success = xml.LoadSb(sbXml,bAutoTrim)

' How many accounts exist?
numAccounts = xml.NumChildrenAt("Accounts")
outFile.WriteLine("numAccounts = " & numAccounts)

i = 0
Do While i < numAccounts
    xml.I = i
    outFile.WriteLine("AccountID: " & xml.GetChildContent("Accounts|Account[i]|AccountID"))
    outFile.WriteLine("Name: " & xml.GetChildContent("Accounts|Account[i]|Name"))
    outFile.WriteLine("Code: " & xml.GetChildIntValue("Accounts|Account[i]|Code"))
    outFile.WriteLine("EnablePaymentsToAccount: " & xml.GetChildBoolValue("Accounts|Account[i]|EnablePaymentsToAccount"))
    outFile.WriteLine("----")
    i = i + 1
Loop

' The output looks like this:

' 	numAccounts = 69
' 	AccountID: ceef66a5-a545-413b-9312-78a53caadbc4
' 	Name: Checking Account
' 	Code: 90
' 	EnablePaymentsToAccount: False
' 	----
' 	AccountID: 3d09fd49-434d-4c18-a57b-831663ab70d2
' 	Name: Savings Account
' 	Code: 91
' 	EnablePaymentsToAccount: False
' 	----
' 	AccountID: 5f5e1b00-5331-4ee5-bc84-39dbd9a27db3
' 	Name: Accounts Receivable
' 	Code: 120
' 	EnablePaymentsToAccount: False
' 	----
' 	AccountID: b0a23f8d-1b6d-4209-96f9-8046f794e1f4
' 	Name: Prepayments
' 	Code: 130
' 	EnablePaymentsToAccount: False
' 	----
' 	...

' The xero_accounts.xml file contains data that looks like this:

' 	<Response xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
' 	  <Id>409d062b-d3c2-4062-99a6-31b7c1c14662</Id>
' 	  <Status>OK</Status>
' 	  <ProviderName>ChilkatPrivate</ProviderName>
' 	  <DateTimeUTC>2016-11-01T22:30:13.3606258Z</DateTimeUTC>
' 	  <Accounts>
' 	    <Account>
' 	      <AccountID>ceef66a5-a545-413b-9312-78a53caadbc4</AccountID>
' 	      <Code>090</Code>
' 	      <Name>Checking Account</Name>
' 	      <Status>ACTIVE</Status>
' 	      <Type>BANK</Type>
' 	      <TaxType>NONE</TaxType>
' 	      <Class>ASSET</Class>
' 	      <EnablePaymentsToAccount>false</EnablePaymentsToAccount>
' 	      <ShowInExpenseClaims>false</ShowInExpenseClaims>
' 	      <BankAccountNumber>132435465</BankAccountNumber>
' 	      <BankAccountType>BANK</BankAccountType>
' 	      <CurrencyCode>USD</CurrencyCode>
' 	      <ReportingCode>ASS</ReportingCode>
' 	      <ReportingCodeName>Assets</ReportingCodeName>
' 	      <HasAttachments>false</HasAttachments>
' 	      <UpdatedDateUTC>2016-10-15T22:22:44.53</UpdatedDateUTC>
' 	    </Account>
' 	    <Account>
' 	      <AccountID>3d09fd49-434d-4c18-a57b-831663ab70d2</AccountID>
' 	      <Code>091</Code>
' 	      <Name>Savings Account</Name>
' 	      <Status>ACTIVE</Status>
' 	      <Type>BANK</Type>
' 	      <TaxType>NONE</TaxType>
' 	      <Class>ASSET</Class>
' 	      <EnablePaymentsToAccount>false</EnablePaymentsToAccount>
' 	      <ShowInExpenseClaims>false</ShowInExpenseClaims>
' 	      <BankAccountNumber>987654321</BankAccountNumber>
' 	      <BankAccountType>BANK</BankAccountType>
' 	      <CurrencyCode>USD</CurrencyCode>
' 	      <ReportingCode>ASS</ReportingCode>
' 	      <HasAttachments>false</HasAttachments>
' 	      <UpdatedDateUTC>2016-10-15T22:22:44.53</UpdatedDateUTC>
' 	    </Account>
' 	    ...
' 

outFile.Close