JSON to XML using XSLT

Question

I met a requirement in which I need to get transfer JSON data into various XML document on the basis of XSLT. In fact, same json data goes to different systems and they have their own object structure (properties nesting level etc) to store it.

I use XslCompiledTransform() in C# to transform Xml into Json; And now looking if there is any efficient way of transforming JSON into XML using XSLT ?

Your question is too broad I'm afraid. Also, XSLT is perhaps a rather poor choice because it is meant to transform XML documents to something else, not the other way round. If you have a working solution in C# already, why would you need to start using XSLT? — Mathias Müller
– Mathias Müller, Commented Oct 22, 2014 at 8:01
@Mathias Müller: Actually, there is a scenario in which same json data goes to different systems and they have their own object structure(properties nesting level etc) to store it. — Anil Kumar
– Anil Kumar, Commented Oct 22, 2014 at 8:06
I think we need more details to be able to help you. As XSLT is taking an xml document as input, it shouldn't be your first call to transform JSON to XML. But if you still have to, you could use a dummy XML doc (aka : <dummy/> as content) for input to your XSLT and use the XSLT function : unparsed-text($documentURI,$encodage) to access your JSON. But you'll still need to access the content of your JSON Data as raw string. — Eric S
– Eric S, Commented Oct 22, 2014 at 10:18

Community · Accepted Answer · 2017-05-23 10:26:00Z

2

I don't think this will work. JSON is not XML based, so you can't apply XSLT transformations on it. XML to JSON would work, but not JSON to XML

Edit. I was wrong, check this: https://github.com/bramstein/xsltjson and this: How to convert json to xml using xslt

edited May 23, 2017 at 10:26

CommunityBot

11 silver badge

answered Oct 22, 2014 at 8:38

molbal

9741 gold badge10 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

liuzhidong · Accepted Answer · 2014-10-22 08:44:25Z

0

XSLT is to change one xml document to another xml document, however, json is not even a xml type document..

you can write a simple application to transfer the format

answered Oct 22, 2014 at 8:44

liuzhidong

5483 silver badges19 bronze badges

Comments

greystate · Accepted Answer · 2014-10-22 23:03:20Z

Setting aside the fact that XSLT is definitely not the right tool for that job, here's a pseudo approach to how I'd do it if I ever had to:

Create an extension function in C# that does the real job, i.e., getting a JSON string as an argument, returning a generic XPathNodeIterator XML chunk.
Process that result normally with XSLT to return the final custom converted format.

The XSLT would then look something like this (assuming XSLT 1.0 since you're in C#):

<xsl:stylesheet version="1.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:util="urn:JsonUtility.Converter"
>
    <!-- Supplied from environment -->
    <xsl:param name="json" />

    <xsl:template match="/">
        <xsl:variable name="xml" select="util:JSON2XML($json)" />

        <!-- Start processing the returned XML -->
        <xsl:apply-templates select="$xml/json" />
    </xsl:template>

    <xsl:template match="key">
        <!-- output -->
    </xsl:template>

    <xsl:template match="array">
        <!-- output -->
    </xsl:template>

    <!-- etc. -->

</xsl:stylesheet>

(Alternatively, if you create the final format in the C# extension, you could just do a <xsl:copy-of select="$xml" /> in the root template.)

Collectives™ on Stack Overflow

JSON to XML using XSLT

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related