XML Help

Description

XML (Extensible Markup Language) is a text format used to store and transport data. XML is a hierarchical structure containing user-defined tags and attributes allowing it to fit specific data needs. XML is both human-readable and machine-readable, which makes it usable in a variety of applications, including web development, software configuration, data interchange between applications, and more.

Upload Settings for XML

Click on Upload Settings button to start configuring the import settings for your XML file.

RECORD

Use this option to tell the system which part of your XML represents one complete entry. Turn this on for the repeating XML element. For example, each <record> inside a list of records.

FIELD

Use this option to tell the system which attributes or nested elements you want to include in your results. Turn this on for any value you want to appear as a column. For example, IDs, names, or balances.

Example

Take the below XML data as an example:

<?xml version='1.0' encoding='UTF-8'?>
<document>
  <record Id="1" AccountNo="101" LastName="Reeves" FirstName="Keanu" Balance="12" CreditLimit="1000.23" AccountCreated="17/01/1998" Rating="A"/>
  <record Id="2" AccountNo="102" LastName="Butler" FirstName="Gerard" Balance="123456" CreditLimit="1234567891" AccountCreated="06/08/2003" Rating="B"/>
  <record Id="3" AccountNo="103" LastName="Hewitt" FirstName="Jennifer" Balance="4294967295" CreditLimit="9876543211" AccountCreated="25/05/1985" Rating="B"/>
</document>

The RECORD switch would be ON for each <record> element (each one is a separate record).

The FIELD switches would be ON for the attributes like Id, AccountNo, LastName, and other details you want as columns.

Once you have configured the settings, click Save Changes to apply them.