convert JSON to XML()
Converts the content of a JSON file in parameter a into XML content.
You can use parameter b to save the generated XML content into an XML object (DOM).
Parameters
|
Parameter |
Description |
|
a |
Value to convert (content of a JSON file). |
|
b |
(optional) If you specify a name here, the generated XML content will be stored in an XML object (DOM). You access this object with function get value from XML(), for example. |
Example
We enter the following JSON content in parameter a.
{ "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" } ]}As a result we get the following XML content.
<root> <JsonData> <termsofpayment1/> <vat2>7</vat2> <ilnsupp>123456789</ilnsupp> <free_text/> <orderno>4711</orderno> <vat1>19</vat1> <ilnreceiver/> <deliverynoteno>0815</deliverynoteno> <invoicno>08154711</invoicno> <termsofpayment2/> <currency>EUR</currency> <ilnbuyer>400000045687</ilnbuyer> <complexposition_position> <amount>200</amount> <unit>PCE</unit> <vat_pos>19</vat_pos> <itemno_supp>87490</itemno_supp> <content>Sausages</content> <positionno>1</positionno> <price>30</price> <EAN>3654878784</EAN> </complexposition_position> <complexposition_position> <amount>1</amount> <unit>PCE</unit> <vat_pos/> <itemno_supp>8786767</itemno_supp> <content/> <positionno>2</positionno> <price>56</price> <EAN>546546</EAN> </complexposition_position> </JsonData></root>