Re: [xsl] json to json transformation

["Martin Honnen martin.honnen@xxxxxx" <xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx>]

On 15.03.2019 11:42, Mukul Gandhi gandhi.mukul@xxxxxxxxx wrote:

> Input JSON fileB person.txt:
>
> {
>  B  B "id" : 105,
>  B  B "medals" : [1, 2, 3],
>  B  B "fName" : "Mukul",
>  B  B "lName" : "Gandhi",
>  B  B "address" : {
>  B  B  B  "street1" : "xyz",
>  B  B  B  "street2" : "maddison avenue",
>  B  B  B  "country" : "C1"
>  B  B  }
> }
>
> I wish to transform above JSON document, into another JSON document 
> which should look like following,
>
> {
>  B  B "id" : 105,
>  B  B "medals" : [1, 2, 3],
>  B  B "name" : "Mukul Gandhi",
>  B  B "address" : {
>  B  B  B  "street1" : "xyz",
>  B  B  B  "street2" : "maddison avenue",
>  B  B  B  "country" : "C1"
>  B  B  }
> }

In general I agree that conversion to XML allows easier processing of 
and transformation of JSON but your simply example could also be done at 
the XPath 3.1 level with map functions:

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

  <xsl:param name="json-string" as="xs:string">{
   "id" : 105,
   "medals" : [1, 2, 3],
   "fName" : "Mukul",
   "lName" : "Gandhi",
   "address" : {
      "street1" : "xyz",
      "street2" : "maddison avenue",
      "country" : "C1"
    }
}</xsl:param>

  <xsl:variable name="map1" select="parse-json($json-string)"/>

  <xsl:template match="/">
      <xsl:sequence select="map:remove(map:put($map1, 'name', 
$map1?fName || ' ' || $map1?lName), ('fName', 'lName'))"/>
  </xsl:template>

BTW: What did you get the medals for?