Using XSLT to transform XML to JSON and add Square bracket [] to the JSON

Question

Am trying to enclose/add square brackets to Json after using XSLT for conversion. I want the Json to be in a list/array form.

Below is my XML file.

<?xml version="1.0" encoding="UTF-8"?>
<map xmlns="http://www.w3.org/2005/xpath-functions">
   <string key="foedselsdato">2019-04-22</string>
   <string key="individId">01387</string>
   <map key="varslinger"/>
</map>

This is my XSL file below.

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    version="3.0">
  <xsl:output omit-xml-declaration="yes"/>
  <xsl:template match="/">
      <xsl:value-of select="xml-to-json(., map { 'indent' : true() })"/>
  </xsl:template>
</xsl:stylesheet>

Using https://xsltfiddle.liberty-development.net/b4GWVd for conversion i get :

{ "foedselsdato" : "2019-04-22",
    "individId" : "01387",
    "varslinger" : 
    {  } }

But I would like to convert it as below:

[{ "foedselsdato" : "2019-04-22",
    "individId" : "01387",
    "varslinger" : 
    {  } }]

How about [concat](https://stackoverflow.com/questions/10395488/how-to-concat-a-string-to-xslvalue-of-select)? — ceving, Sep 18 '20 at 08:46
How do i do that, am getting error "An atomic value is required for the third argument of fn:concat(" when I use expression — Kevin Mbugua, Sep 18 '20 at 09:00

score 2 · Accepted Answer · answered Sep 18 '20 at 10:43

If you want to work with the XDM representation of JSON in XPath 3.1 and XSLT 3 you can use

  <xsl:output method="json" indent="yes"/>

  <xsl:template match="/">
      <xsl:sequence select="array { xml-to-json(.) => parse-json() }"/>
  </xsl:template>

to wrap the previous JSON into an array: https://xsltfiddle.liberty-development.net/b4GWVd/81

Kevin Mbugua · Answer 2 · 2020-09-18T11:25:22.663

The below code worked.

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    version="3.0">
  <xsl:output omit-xml-declaration="yes"/>
  <xsl:template match="/">
      <xsl:text>[</xsl:text>
      <xsl:value-of select="xml-to-json(., map { 'indent' : true() })"/>
      <xsl:text>]</xsl:text>
  </xsl:template>
</xsl:stylesheet>

Or

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    version="3.0">
  <xsl:output omit-xml-declaration="yes"/>
  <xsl:template match="/">
      <xsl:text>[</xsl:text>
      <xsl:value-of select="concat('[',xml-to-json(., map { 'indent' : true() }))"/>
      <xsl:text>]</xsl:text>
  </xsl:template>
  </xsl:stylesheet>

Using XSLT to transform XML to JSON and add Square bracket [] to the JSON

2 Answers2