|
|
 top
|
  Subject: XML To JSON Conversion using XSLT
Author: cHANDRA Sekhar
Date: 25 May 2020 05:55 PM
|
hI,
I have source file as
<?xml version="1.0" encoding="UTF-8"?>
<ns0:DocumentCoding xmlns:ns0="http://HELP.com/BMU/PurchaseOrderCreate">
<DocumentId>78D6590F-2843-434D-AF0F-76B11680B6AD</DocumentId>
<CodingLines>
<CodingLines>
<ID>
<value>d54be956-b6c6-4990-a4e9-2059d695c2e8</value>
</ID>
<OrderLineReference>
<LineID>
<value>1</value>
</LineID>
</OrderLineReference>
<Amount>
<value>7000000.00</value>
<currencyID>USD</currencyID>
</Amount>
<Quantity>
<value>100000</value>
<unitCode>EA</unitCode>
</Quantity>
<Codes>
<ID/>
<Name>
<value>Hexion Inc. - Louisville</value>
</Name>
<Value>
<value>US-108</value>
</Value>
</Codes>
<Codes>
<ID/>
<Name>
<value>Reserve for Source</value>
</Name>
<Value>
<value>530</value>
</Value>
</Codes>
<Codes>
<ID/>
<Name>
<value>Flower stands</value>
</Name>
<Value>
<value>56101606</value>
</Value>
</Codes>
<Codes>
<ID/>
<Name>
<value>GR/IR</value>
</Name>
<Value>
<value>191100</value>
</Value>
</Codes>
</CodingLines>
</CodingLines>
</ns0:DocumentCoding>
The target file which is been expected is JSON file as below
{"DocumentId":"41DCF8A4-6D05-4A8F-9265-F5E6BCD96CCF","CodingLines":{{"CodingLines":[{"ID":{"value":"177AFD35-5EF5-4466-88C6-B4755CC2E1A0"},"OrderLineReference":[{"LineID":{"value":"00001"}}],"CurrentDocumentLineReferenceId":"00001","Amount":{"value":"100.00 ","currencyID":"USD"},"Quantity":{"value":"100.000 ","unitCode":"GIA"},"Codes":[{"ID":{"value":"purchasinggroup"},"Name":{"value":"Reserve for Source"},"Value":{"value":108}}]}]}}}
Can you please help me with XSLT File to be used for conversion of XML To JSON file.
Thanks,
Sekhar
|
|
|
|
