XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Conferences Close Tree View
+ Stylus Studio Feature Requests (1189)
+ Stylus Studio Technical Forum (14588)
+ Website Feedback (247)
- XSLT Help and Discussion (7618)
-> + Use of before and after string (3) Sticky Topic
-> - Help, I have existing XLT and... (1)
-> + Need help on XSLT issue - (2)
-> + EDI to XML Conversion (7)
-> - XML To JSON Conversion using X... (1)
-> + Formatting Paragraphs to same ... (2)
-> - Grouping of records (1)
-> + Problems with xsd 1.1 (4)
-> + XML to HL7 mapping (2)
-> - XSLT 3 and Iterate (1)
-> + XSL-FO to PDF preview (3)
-> + java.lang.RuntimeException: Er... (2)
-> + Create Acroforms with Stylus X... (2)
-> + How to change XSLT parameter s... (3)
-> + how to change format of the da... (2)
-> + Search "Next 8 Results " doesn... (2)
-> - Support for Git (1)
-> + newbee (8)
-> + How to substitute element or t... (2)
-> + Xalan support in x16? (2)
-- [1-20] [21-40] [41-60] Next
+ XQuery Help and Discussion (1975)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Posttop
cHANDRA SekharSubject: 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

   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.