convert XML to JSON()

Prev Next

This function converts the text of an XML file or an XML DOM object into the text of a JSON file.

Parameters

Parameter

Description

a

The text of an XML file or the name of an XML DOM object, see function parse XML(). See also parameter b.

b

(option) "true", if an XML DOM object was specified in parameter a. Default: "false".

c

(optional) "true" to format the JSON text (pretty format). Default: "false".

Example

Assume the following XML file.

<Order date="today">
	<line>
		<product pos="1" ean="0815" amount="2.0" vat="19%" net="100">
			<description>article@pos 1</description>
		</product>
	</line>
	<line>
		<product pos="2" ean="4711" amount="1.0" vat="19%" net="145.34">
			<description>article@pos 2</description>
		</product>
	</line>
	<footer totalSum="345.34">end of order</footer>
</Order>

This will result in the following JSON file.

{
   "Order":{
      "date":"today",
      "line":[
         {
            "product":{
               "pos":"1",
               "ean":"0815",
               "amount":"2.0",
               "vat":"19%",
               "net":"100",
               "description":"article@pos 1"
            }
         },
         {
            "product":{
               "pos":"2",
               "ean":"4711",
               "amount":"1.0",
               "vat":"19%",
               "net":"145.34",
               "description":"article@pos 2"
            }
         }
      ],
      "footer":{
         "totalSum":"345.34",
         "Text":"end of order"
      }
   }
}