Java

Demonstrate the XML "I" Property

See more XML Examples

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.

Chilkat2 Java

import com.chilkatsoft.chilkat2.ChilkatException;
import com.chilkatsoft.chilkat2.Http;
import com.chilkatsoft.chilkat2.StringBuilder;
import com.chilkatsoft.chilkat2.Xml;

public class ChilkatExample {

    public static void main(String[] args) {
        // 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.

        StringBuilder sbXml = new StringBuilder();

        // Download the XML from https://www.chilkatsoft.com/exampleData/xero_accounts.xml
        // into sbXml
        String url = "https://www.chilkatsoft.com/exampleData/xero_accounts.xml";
        Http http = new Http();
        try {
            http.quickGetSb(url, sbXml);
        } catch (ChilkatException e) {
            System.out.println(e.getLastErrorText());
            return;
        }

        boolean bAutoTrim = false;
        Xml xml = new Xml();
        xml.loadSb(sbXml, bAutoTrim);

        // How many accounts exist?
        int numAccounts = xml.numChildrenAt("Accounts");
        System.out.println("numAccounts = " + numAccounts);

        int i = 0;
        while (i < numAccounts) {
            xml.setI(i);
            System.out.println("AccountID: " + xml.getChildContent("Accounts|Account[i]|AccountID"));
            System.out.println("Name: " + xml.getChildContent("Accounts|Account[i]|Name"));
            System.out.println("Code: " + xml.getChildIntValue("Accounts|Account[i]|Code"));
            System.out.println("EnablePaymentsToAccount: " + xml.getChildBoolValue("Accounts|Account[i]|EnablePaymentsToAccount"));
            System.out.println("----");
            i = i + 1;
        }

        // 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>
        //         ...
        //
    }
}