JsonToXmlPreparser

Configuration file

None.

Class name

com.ebd.hub.datawizard.parser.JsonToXmlPreparser

Description


This preparser is deprecated.

This preparser is able to convert a JSON document into an XML file, which can be parsed by the XML parser.

Important note: The root node to parse the XML file should always be "JsonData". This ensures that multiple records are created if the JSON object is a list.

Example


The file "demo.json" is converted into "demo.xml".


demo.json
{
"termsofpayment1":"",
"vat2":"7",
"ilnsupp":"123456789",
"free_text":"",
"orderno":"4711",
"vat1":"19",
"ilnreceiver":"",
"deliverynoteno":"0815",
"invoicno":"08154711",
"termsofpayment2":"",
"currency":"EUR",
"ilnbuyer":"400000045687",
"complexposition_position":[
{
"amount":200,
"unit":"PCE",
"vat_pos":"19",
"itemno_supp":"87490",
"content":"Sausages",
"positionno":"1",
"price":30,
"EAN":"3654878784"
},
{
"amount":1,
"unit":"PCE",
"vat_pos":"",
"itemno_supp":"8786767",
"content":"",
"positionno":"2",
"price":56,
"EAN":"546546"
}
]
}

demo.xml
<?xml version="1.0" encoding="UTF-8"?>
<JsonData>
<deliverynoteno>0815</deliverynoteno>
<termsofpayment1/>
<termsofpayment2/>
<vat2>7</vat2>
<ilnsupp>123456789</ilnsupp>
<free_text/>
<ilnreceiver/>
<invoicno>08154711</invoicno>
<currency>EUR</currency>
<orderno>4711</orderno>
<vat1>19</vat1>
<ilnbuyer>400000045687</ilnbuyer>
<complexposition_position>
<itemno_supp>87490</itemno_supp>
<vat_pos>19</vat_pos>
<positionno>1</positionno>
<price>30</price>
<EAN>3654878784</EAN>
<content>Sausages</content>
<amount>200</amount>
<unit>PCE</unit>
</complexposition_position>
<complexposition_position>
<itemno_supp>8786767</itemno_supp>
<vat_pos/>
<positionno>2</positionno>
<price>56</price>
<EAN>546546</EAN>
<content/>
<amount>1</amount>
<unit>PCE</unit>
</complexposition_position>
</JsonData>