Geek Answers Handbook

How to convert json to xml using xslt

How would you convert JSON to XML?

Consider:

<sampleTag> { "Order": { "InvestmentAccount": { "AccountNumber": "10" }, "Parcel": { "Limit": "0", "ExpiryDate": "1900-01-01T00:00:00", "Asset": [ { "Open": "25.15", "High": "25.15", "Low": "25.11", "Close": "25.87" } { "Open": "25.15", "High": "25.15", "Low": "25.11", "Close": "25.87" }] }, "OrderDate": "2012-10-11T21:46:03.6489906+11:00", } } </sampleTag>

After conversion, the document is as follows:

 <Order> <InvestmentAccount> <AccountNumber>10</AccountNumber> </InvestmentAccount> <Parcel> <Limit>0</Limit> <ExpiryDate>1900-01-01T00:00:00</ExpiryDate> <Asset> <Open>25.15</Open> <High>25.15</High> <Low>25.11</Low> <Close>25.87</Close> </Asset> <Asset> <Open>25.15</Open> <High>25.15</High> <Low>25.11</Low> <Close>25.87</Close> </Asset> </Parcel> <OrderDate>2012-10-11T21:46:03.6489906+11:00</OrderDate> </Order>
+6
source share
7 answers

My work on parsing JSON does not extend to the full JSON grammar.

And the task of "translating" any JSON document into an XML document has no solution. There are JSON constructs that cannot be translated into XML without defining additional conventions and introducing additional elements, so the final XML structure is not a true and natural representation of the original JSON object.

In XSLT 3.0, there is a function for analyzing any JSON object - parse-json () - to map - a new data type introduced in XSLT 3.0. Read about it here: http://www.w3.org/TR/xslt-30/#json

+8
source

Actually, this is not so difficult. A way to get closer to her is to study Jason's syntax and view each production as it was a template. I was just about to write a solution when I considered the possibility that the OP forgot google for existing solutions. I searched and looked.

UPDATE

Here is the JSon to XML converter. But it only works on a subset of json. Hopefully the subset is wide enough for your specific needs. In particular, the limitations are:

  • Only a simple type is supported — a string. No integer, logical, or null.
  • Json object names must be valid xml element names.
  • Evacuation codes are not allowed in string values. This means that you cannot transfer transport values ​​that include, for example, a "character (without pitching your own encoding layer).

This XSLT 1.0 Style Sheet ... *

 <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:json="http://www.ibm.com/xmlns/prod/2009/jsonx" xmlns:exsl="http://exslt.org/common" xmlns:so="http://stackoverflow.com/questions/13007280" exclude-result-prefixes="xsl xs json so exsl"> <xsl:output indent="yes" encoding="UTF-8" omit-xml-declaration="yes" /> <xsl:strip-space elements="*" /> <xsl:variable name="quot" select="'&quot;'" /> <xsl:template match="/*"> <xsl:variable name="t1"> <xsl:call-template name="object"> <xsl:with-param name="json-in" select="." /> </xsl:call-template> </xsl:variable> <xsl:apply-templates select="exsl:node-set($t1)/so:output/*" mode="copy-sans-namespace" /> </xsl:template> <xsl:template match="*" mode="copy-sans-namespace"> <xsl:element name="{name()}" namespace="{namespace-uri()}"> <xsl:copy-of select="@*"/> <xsl:apply-templates mode="copy-sans-namespace" /> </xsl:element> </xsl:template> <xsl:template name="field"> <!-- Input like: "Open": "25.15" bla --> <!-- output like: <so:output><Open>25.15</Open></so:output> <so:extra>bla</so:extra> --> <xsl:param name="json-in" /> <xsl:variable name="field-name" select="substring-before(substring-after($json-in,$quot),$quot)" /> <xsl:variable name="remainder" select="substring-after($json-in,':')" /> <xsl:call-template name="value"> <xsl:with-param name="json-in" select="$remainder" /> <xsl:with-param name="parent-ele" select="$field-name" /> </xsl:call-template> </xsl:template> <xsl:template name="fields"> <!-- Input like: "Open": "25.15" , "High": "25.15" } bla --> <!-- output like: <so:output><Open>25.15</Open><High>25.15</High></so:output> <so:extra>} bla</so:extra> --> <xsl:param name="json-in" /> <xsl:variable name="n" select="normalize-space($json-in)" /> <xsl:choose> <xsl:when test="substring($n,1,1) = $quot"> <xsl:variable name="t1"> <xsl:call-template name="field"> <xsl:with-param name="json-in" select="$n" /> </xsl:call-template> </xsl:variable> <xsl:variable name="t2" select="normalize-space( exsl:node-set($t1)/so:extra) " /> <xsl:variable name="t3"> <xsl:choose> <xsl:when test="substring($t2,1,1)=','"> <xsl:call-template name="fields"> <xsl:with-param name="json-in" select="substring-after($t2,',')" /> </xsl:call-template> </xsl:when> <xsl:when test="$t2"> <so:extra><xsl:value-of select="$t2" /></so:extra> </xsl:when> </xsl:choose> </xsl:variable> <so:output> <xsl:copy-of select="exsl:node-set($t1)/so:output/* | exsl:node-set($t3)/so:output/*" /> </so:output> <xsl:copy-of select="exsl:node-set($t3)/so:extra" /> </xsl:when> <xsl:when test="$n"> <so:extra><xsl:value-of select="$n" /></so:extra> </xsl:when> </xsl:choose> </xsl:template> <xsl:template name="object"> <!-- Input like: { X } bla --> <!-- output like: <so:output>fields(X)</so:output> <so:extra>bla</so:extra> --> <xsl:param name="json-in" /> <xsl:param name="parent-ele" select="''" /> <xsl:variable name="t1" select="normalize-space(substring-after($json-in,'{'))" /> <xsl:variable name="t2"> <xsl:call-template name="fields"> <xsl:with-param name="json-in" select="$t1" /> </xsl:call-template> </xsl:variable> <xsl:variable name="t3" select="normalize-space(substring-after( exsl:node-set($t2)/so:extra, '}'))" /> <so:output> <xsl:choose> <xsl:when test="$parent-ele"> <xsl:element name="{$parent-ele}"> <xsl:copy-of select="exsl:node-set($t2)/so:output/node()" /> </xsl:element> </xsl:when> <xsl:otherwise> <xsl:copy-of select="exsl:node-set($t2)/so:output/node()" /> </xsl:otherwise> </xsl:choose> </so:output> <xsl:if test="$t3"> <so:extra><xsl:value-of select="$t3" /></so:extra> </xsl:if> </xsl:template> <xsl:template name="objects"> <xsl:param name="json-in" /> <xsl:param name="parent-ele" /> <xsl:variable name="n" select="normalize-space($json-in)" /> <xsl:choose> <xsl:when test="substring($n,1,1) = '{'"> <xsl:variable name="t1"> <xsl:call-template name="object"> <xsl:with-param name="json-in" select="$n" /> <xsl:with-param name="parent-ele" select="$parent-ele" /> </xsl:call-template> </xsl:variable> <xsl:variable name="t2" select="normalize-space( exsl:node-set($t1)/so:extra) " /> <xsl:variable name="t3"> <xsl:choose> <xsl:when test="substring($t2,1,1)='{'"> <xsl:call-template name="objects"> <xsl:with-param name="json-in" select="$t2" /> <xsl:with-param name="parent-ele" select="$parent-ele" /> </xsl:call-template> </xsl:when> <xsl:when test="$t2"> <so:extra><xsl:value-of select="$t2" /></so:extra> </xsl:when> </xsl:choose> </xsl:variable> <so:output> <xsl:copy-of select="exsl:node-set($t1)/so:output/* | exsl:node-set($t3)/so:output/*" /> </so:output> <xsl:copy-of select="exsl:node-set($t3)/so:extra" /> </xsl:when> <xsl:when test="$n"> <so:extra><xsl:value-of select="$n" /></so:extra> </xsl:when> </xsl:choose> </xsl:template> <xsl:template name="array"> <!-- Input like: [ X1 X2 ] bla --> <!-- output like: <so:output><Y>X1</Y><Y>X2</Y></so:output> <so:extra>}bla</so:extra> --> <xsl:param name="json-in" /> <xsl:param name="parent-ele" /> <xsl:variable name="t1" select="normalize-space(substring-after($json-in,'['))" /> <xsl:variable name="t2"> <xsl:call-template name="objects"> <xsl:with-param name="json-in" select="$t1" /> <xsl:with-param name="parent-ele" select="$parent-ele" /> </xsl:call-template> </xsl:variable> <xsl:variable name="t3" select="normalize-space(substring-after( exsl:node-set($t2)/so:extra, ']'))" /> <xsl:copy-of select="exsl:node-set($t2)/so:output" /> <xsl:if test="$t3"> <so:extra><xsl:value-of select="$t3" /></so:extra> </xsl:if> </xsl:template> <xsl:template name="value"> <!-- Input like either array, object or string --> <!-- output like either array, object or string --> <xsl:param name="json-in" /> <xsl:param name="parent-ele" /> <xsl:variable name="first-letter" select="substring(normalize-space($json-in),1,1)" /> <xsl:choose> <xsl:when test="$first-letter='{'"> <xsl:call-template name="object"> <xsl:with-param name="json-in" select="$json-in" /> <xsl:with-param name="parent-ele" select="$parent-ele" /> </xsl:call-template> </xsl:when> <xsl:when test="$first-letter='['"> <xsl:call-template name="array"> <xsl:with-param name="json-in" select="$json-in" /> <xsl:with-param name="parent-ele" select="$parent-ele" /> </xsl:call-template> </xsl:when> <xsl:when test="$first-letter=$quot"> <xsl:call-template name="string"> <xsl:with-param name="json-in" select="$json-in" /> <xsl:with-param name="parent-ele" select="$parent-ele" /> </xsl:call-template> </xsl:when> <xsl:otherwise> <so:output>ERROR</so:output> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="string"> <!-- Input like: "X" bla --> <!-- output like: <so:output><Y>X</Y></so:output> <so:extra>bla</so:extra> --> <xsl:param name="json-in" /> <xsl:param name="parent-ele" /> <xsl:variable name="value" select="substring-before(substring-after($json-in,$quot),$quot)" /> <xsl:variable name="remainder" select="normalize-space(substring-after(substring-after($json-in,$quot),$quot))" /> <so:output> <xsl:element name="{$parent-ele}"> <xsl:value-of select="$value" /> </xsl:element> </so:output> <xsl:if test="$remainder"> <so:extra><xsl:value-of select="$remainder" /></so:extra> </xsl:if> </xsl:template> </xsl:stylesheet>

... applies to this input (modified from OP, supplied to remove the extraneous comma) ...

 <sampleTag> { "Order": { "InvestmentAccount": { "AccountNumber": "10" }, "Parcel": { "Limit": "0", "ExpiryDate": "1900-01-01T00:00:00", "Asset": [ { "Open": "25.15", "High": "25.15", "Low": "25.11", "Close": "25.87" } { "Open": "25.15", "High": "25.15", "Low": "25.11", "Close": "25.87" }] }, "OrderDate": "2012-10-11T21:46:03.6489906+11:00" } } </sampleTag>

.. gives ...

 <Order> <InvestmentAccount> <AccountNumber>10</AccountNumber> </InvestmentAccount> <Parcel> <Limit>0</Limit> <ExpiryDate>1900-01-01T00:00:00</ExpiryDate> <Asset> <Open>25.15</Open> <High>25.15</High> <Low>25.11</Low> <Close>25.87</Close> </Asset> <Asset> <Open>25.15</Open> <High>25.15</High> <Low>25.11</Low> <Close>25.87</Close> </Asset> </Parcel> <OrderDate>2012-10-11T21:46:03.6489906+11:00</OrderDate> </Order>
+4
source

I faked a little pattern of Sean B. Durkin and thought that I would share.

Updates include:

  • Room Support
  • Boolean support
  • Fix for elements of an array of objects separated by a comma (according to the JSON specification)

Changes without updating:

  • Array elements are displayed in native XML elements with the element name as the key of the object marked with _element

Still not supported:

  • Escaped characters (quotation marks) in strings

Here's the pattern:

 <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:json="http://www.ibm.com/xmlns/prod/2009/jsonx" xmlns:exsl="http://exslt.org/common" xmlns:so="http://stackoverflow.com/questions/13007280" exclude-result-prefixes="xsl xs json so exsl"> <xsl:output indent="yes" encoding="UTF-8" /> <xsl:strip-space elements="*" /> <xsl:variable name="quot" select="'&quot;'" /> <xsl:variable name="numbers" select="'0123456789'"/> <xsl:variable name="booleans" select="'tf'"/> <xsl:template match="/*"> <xsl:variable name="t1"> <xsl:call-template name="object"> <xsl:with-param name="json-in" select="." /> </xsl:call-template> </xsl:variable> <xsl:apply-templates select="exsl:node-set($t1)/so:output/*" mode="copy-sans-namespace" /> </xsl:template> <xsl:template match="*" mode="copy-sans-namespace"> <xsl:element name="{name()}" namespace="{namespace-uri()}"> <xsl:copy-of select="@*"/> <xsl:apply-templates mode="copy-sans-namespace" /> </xsl:element> </xsl:template> <xsl:template name="field"> <!-- Input like: "Open": "25.15" bla --> <!-- output like: <so:output><Open>25.15</Open></so:output> <so:extra>bla</so:extra> --> <xsl:param name="json-in" /> <xsl:variable name="field-name" select="substring-before(substring-after($json-in,$quot),$quot)" /> <xsl:variable name="remainder" select="substring-after($json-in,':')" /> <xsl:call-template name="value"> <xsl:with-param name="json-in" select="$remainder" /> <xsl:with-param name="parent-ele" select="$field-name" /> </xsl:call-template> </xsl:template> <xsl:template name="fields"> <!-- Input like: "Open": "25.15" , "High": "25.15" } bla --> <!-- output like: <so:output><Open>25.15</Open><High>25.15</High></so:output> <so:extra>} bla</so:extra> --> <xsl:param name="json-in" /> <xsl:variable name="n" select="normalize-space($json-in)" /> <xsl:choose> <xsl:when test="substring($n,1,1) = $quot"> <xsl:variable name="t1"> <xsl:call-template name="field"> <xsl:with-param name="json-in" select="$n" /> </xsl:call-template> </xsl:variable> <xsl:variable name="t2" select="normalize-space( exsl:node-set($t1)/so:extra) " /> <xsl:variable name="t3"> <xsl:choose> <xsl:when test="substring($t2,1,1)=','"> <xsl:call-template name="fields"> <xsl:with-param name="json-in" select="substring-after($t2,',')" /> </xsl:call-template> </xsl:when> <xsl:when test="$t2"> <so:extra><xsl:value-of select="$t2" /></so:extra> </xsl:when> </xsl:choose> </xsl:variable> <so:output> <xsl:copy-of select="exsl:node-set($t1)/so:output/* | exsl:node-set($t3)/so:output/*" /> </so:output> <xsl:copy-of select="exsl:node-set($t3)/so:extra" /> </xsl:when> <xsl:when test="$n"> <so:extra><xsl:value-of select="$n" /></so:extra> </xsl:when> </xsl:choose> </xsl:template> <xsl:template name="object"> <!-- Input like: { X } bla --> <!-- output like: <so:output>fields(X)</so:output> <so:extra>bla</so:extra> --> <xsl:param name="json-in" /> <xsl:param name="parent-ele" select="''" /> <xsl:variable name="t1" select="normalize-space(substring-after($json-in,'{'))" /> <xsl:variable name="t2"> <xsl:call-template name="fields"> <xsl:with-param name="json-in" select="$t1" /> </xsl:call-template> </xsl:variable> <xsl:variable name="t3" select="normalize-space(substring-after( exsl:node-set($t2)/so:extra, '}'))" /> <so:output> <xsl:choose> <xsl:when test="$parent-ele"> <xsl:element name="{$parent-ele}"> <xsl:copy-of select="exsl:node-set($t2)/so:output/node()" /> </xsl:element> </xsl:when> <xsl:otherwise> <xsl:copy-of select="exsl:node-set($t2)/so:output/node()" /> </xsl:otherwise> </xsl:choose> </so:output> <xsl:if test="$t3"> <so:extra><xsl:value-of select="$t3" /></so:extra> </xsl:if> </xsl:template> <xsl:template name="objects"> <xsl:param name="json-in" /> <xsl:param name="parent-ele" /> <xsl:variable name="n" select="normalize-space($json-in)" /> <xsl:choose> <xsl:when test="substring($n,1,1) = '{'"> <xsl:variable name="t1"> <xsl:call-template name="object"> <xsl:with-param name="json-in" select="$n" /> <xsl:with-param name="parent-ele" select="$parent-ele" /> </xsl:call-template> </xsl:variable> <xsl:variable name="t2" select="normalize-space( exsl:node-set($t1)/so:extra) " /> <xsl:variable name="t3"> <xsl:choose> <xsl:when test="substring($t2,1,1)='{'"> <xsl:call-template name="objects"> <xsl:with-param name="json-in" select="$t2" /> <xsl:with-param name="parent-ele" select="$parent-ele" /> </xsl:call-template> </xsl:when> <xsl:when test="substring($t2,1,1)=',' and substring(normalize-space(substring-after($t2,',')),1,1)='{'"> <xsl:call-template name="objects"> <xsl:with-param name="json-in" select="normalize-space(substring-after($t2,','))" /> <xsl:with-param name="parent-ele" select="$parent-ele" /> </xsl:call-template> </xsl:when> <xsl:when test="$t2"> <so:extra><xsl:value-of select="$t2" /></so:extra> </xsl:when> </xsl:choose> </xsl:variable> <so:output> <xsl:copy-of select="exsl:node-set($t1)/so:output/* | exsl:node-set($t3)/so:output/*" /> </so:output> <xsl:copy-of select="exsl:node-set($t3)/so:extra" /> </xsl:when> <xsl:when test="$n"> <so:extra><xsl:value-of select="$n" /></so:extra> </xsl:when> </xsl:choose> </xsl:template> <xsl:template name="array"> <!-- Input like: [ X1 X2 ] bla --> <!-- output like: <so:output><Y>X1</Y><Y>X2</Y></so:output> <so:extra>}bla</so:extra> --> <xsl:param name="json-in" /> <xsl:param name="parent-ele" /> <xsl:variable name="t1" select="normalize-space(substring-after($json-in,'['))" /> <xsl:variable name="t2"> <xsl:call-template name="objects"> <xsl:with-param name="json-in" select="$t1" /> <xsl:with-param name="parent-ele" select="$parent-ele" /> </xsl:call-template> </xsl:variable> <xsl:variable name="t3"> <xsl:choose> <xsl:when test="contains(substring-before(exsl:node-set($t2)/so:extra,']'),',')"> <xsl:value-of select="normalize-space(substring-after(exsl:node-set($t2)/so:extra,','))"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="normalize-space(substring-after(exsl:node-set($t2)/so:extra,']'))"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="t4"> <xsl:element name="{$parent-ele}"> <xsl:for-each select="$t2/so:output/*[local-name(.)=$parent-ele]"> <xsl:variable name="self" select="."/> <xsl:variable name="tempResult"> <xsl:element name="{concat($parent-ele,'_element')}"> <xsl:copy-of select="exsl:node-set($self/*)" /> </xsl:element> </xsl:variable> <xsl:copy-of select="exsl:node-set($tempResult)"/> </xsl:for-each> </xsl:element> </xsl:variable> <xsl:variable name="t5" select="exsl:node-set($t4)"/> <so:output> <xsl:copy-of select="$t5"/> </so:output> <xsl:if test="$t3"> <so:extra><xsl:value-of select="$t3" /></so:extra> </xsl:if> </xsl:template> <xsl:template name="value"> <!-- Input like either array, object or string --> <!-- output like either array, object or string --> <xsl:param name="json-in" /> <xsl:param name="parent-ele" /> <xsl:variable name="first-letter" select="substring(normalize-space($json-in),1,1)" /> <xsl:choose> <xsl:when test="$first-letter='{'"> <xsl:call-template name="object"> <xsl:with-param name="json-in" select="$json-in" /> <xsl:with-param name="parent-ele" select="$parent-ele" /> </xsl:call-template> </xsl:when> <xsl:when test="$first-letter='['"> <xsl:call-template name="array"> <xsl:with-param name="json-in" select="$json-in" /> <xsl:with-param name="parent-ele" select="$parent-ele" /> </xsl:call-template> </xsl:when> <xsl:when test="$first-letter=$quot"> <xsl:call-template name="string"> <xsl:with-param name="json-in" select="$json-in" /> <xsl:with-param name="parent-ele" select="$parent-ele" /> </xsl:call-template> </xsl:when> <xsl:when test="contains($numbers,$first-letter)"> <xsl:call-template name="number"> <xsl:with-param name="json-in" select="$json-in" /> <xsl:with-param name="parent-ele" select="$parent-ele"/> </xsl:call-template> </xsl:when> <xsl:when test="contains($booleans,$first-letter)"> <xsl:call-template name="boolean"> <xsl:with-param name="json-in" select="$json-in" /> <xsl:with-param name="parent-ele" select="$parent-ele"/> </xsl:call-template> </xsl:when> <xsl:otherwise> <so:output>ERROR</so:output> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="string"> <!-- Input like: "X" bla --> <!-- output like: <so:output><Y>X</Y></so:output> <so:extra>bla</so:extra> --> <xsl:param name="json-in" /> <xsl:param name="parent-ele" /> <xsl:variable name="value" select="substring-before(substring-after($json-in,$quot),$quot)" /> <xsl:variable name="remainder" select="normalize-space(substring-after(substring-after($json-in,$quot),$quot))" /> <so:output> <xsl:element name="{$parent-ele}"> <xsl:value-of select="$value" /> </xsl:element> </so:output> <xsl:if test="$remainder"> <so:extra><xsl:value-of select="$remainder" /></so:extra> </xsl:if> </xsl:template> <xsl:template name="number"> <!-- Input like: "X" bla --> <!-- output like: <so:output><Y>X</Y></so:output> <so:extra>bla</so:extra> --> <xsl:param name="json-in" /> <xsl:param name="parent-ele" /> <xsl:variable name="value"> <xsl:choose> <xsl:when test="contains(substring-before($json-in,','),'}')"> <xsl:value-of select="normalize-space(substring-before($json-in,'}'))"/> </xsl:when> <xsl:when test="contains(substring-before($json-in,','),']')"> <xsl:value-of select="normalize-space(substring-before($json-in,']'))"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="normalize-space(substring-before($json-in,','))"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="remainder"> <xsl:choose> <xsl:when test="contains(substring-before($json-in,','),'}')"> <xsl:value-of select="concat('}',normalize-space(substring-after($json-in,'}')))"/> </xsl:when> <xsl:when test="contains(substring-before($json-in,','),']')"> <xsl:value-of select="concat(']',normalize-space(substring-after($json-in,']')))"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="concat(',',normalize-space(substring-after($json-in,',')))"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <so:output> <xsl:element name="{$parent-ele}"> <xsl:value-of select="$value" /> </xsl:element> </so:output> <xsl:if test="$remainder"> <so:extra><xsl:value-of select="$remainder" /></so:extra> </xsl:if> </xsl:template> <xsl:template name="boolean"> <!-- Input like: "X" bla --> <!-- output like: <so:output><Y>X</Y></so:output> <so:extra>bla</so:extra> --> <xsl:param name="json-in" /> <xsl:param name="parent-ele" /> <xsl:variable name="value"> <xsl:choose> <xsl:when test="contains(substring-before($json-in,','),'}')"> <xsl:value-of select="normalize-space(substring-before($json-in,'}'))"/> </xsl:when> <xsl:when test="contains(substring-before($json-in,','),']')"> <xsl:value-of select="normalize-space(substring-before($json-in,']'))"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="normalize-space(substring-before($json-in,','))"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="remainder"> <xsl:choose> <xsl:when test="contains(substring-before($json-in,','),'}')"> <xsl:value-of select="concat('}',normalize-space(substring-after($json-in,'}')))"/> </xsl:when> <xsl:when test="contains(substring-before($json-in,','),']')"> <xsl:value-of select="concat(']',normalize-space(substring-after($json-in,']')))"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="concat(',',normalize-space(substring-after($json-in,',')))"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <so:output> <xsl:element name="{$parent-ele}"> <xsl:value-of select="$value" /> </xsl:element> </so:output> <xsl:if test="$remainder"> <so:extra><xsl:value-of select="$remainder" /></so:extra> </xsl:if> </xsl:template> </xsl:stylesheet>

So, with this (adjusted) input:

 <?xml version="1.0" encoding="UTF-8"?> <sampleTag><![CDATA[ { "Order": { "InvestmentAccount": { "AccountNumber": "10" }, "Parcel": { "Limit": 0, "ExpiryDate": "1900-01-01T00:00:00", "valid": true, "Asset": [ { "Open": 25.15, "High": 25.15, "Low": 25.11, "Close": 25.87 }, { "Open": 25.15, "High": 25.15, "Low": 25.11, "Close": 25.87 } ] }, "OrderDate": "2012-10-11T21:46:03.6489906+11:00" } } ]]></sampleTag>

I get this output:

 <?xml version="1.0" encoding="UTF-8"?> <Order> <InvestmentAccount> <AccountNumber>10</AccountNumber> </InvestmentAccount> <Parcel> <Limit>0</Limit> <ExpiryDate>1900-01-01T00:00:00</ExpiryDate> <valid>true</valid> <Asset> <Asset_element> <Open>25.15</Open> <High>25.15</High> <Low>25.11</Low> <Close>25.87</Close> </Asset_element> <Asset_element> <Open>25.15</Open> <High>25.15</High> <Low>25.11</Low> <Close>25.87</Close> </Asset_element> </Asset> </Parcel> <OrderDate>2012-10-11T21:46:03.6489906+11:00</OrderDate> </Order>
+1
source

In addition to the Dimitre XSLT parsing structure, there is also a Hunter Rademacher Rex parser generator that also includes JSON as one of its sample grammars:

http://www.bottlecaps.de/rex/

0
source

Try this lib:

https://github.com/bramstein/xsltjson

It looks very nice.

This is a 2.0 XSLT solution, although it also points to version 1.0.

0
source

The question is tagged for XSLT 1.0, so I don't know if this answer will help the original question. But if you can use XSLT 3.0, the json-to-xml function does exactly what you need.

https://www.w3.org/TR/xslt-30/#func-json-to-xml

0
source

XSLT has many advantages and several big disadvantages. Text processing is its weakness, at least version 1.0. Although it would be technically possible to process this text with XSLT 1.0, I can’t think of any situation where it will be a very good idea and where it will not be very fragile conversion. The code that you will need to produce will be very cumbersome.

Do you have another language to process?

-1
source

More articles:


All Articles