JSON to XML Conversion using XSLT

Consider the following example:

XML (containing a valid(!) JSON)

<JSON>
{
    "daywisedata" : 
    {
        "2022-01-11" : 
        {
            "total_cost" : 0,
            "total_earning" : 10
        },
        "2022-01-12" : 
        {
            "total_cost" : 10,
            "total_earning" : 5
        },
        "2022-01-13" : 
        {
            "total_cost" : 15,
            "total_earning" : 20
        }
    }
}
</JSON>

XSLT 3.0

<xsl:stylesheet version="3.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes"/>

<xsl:template match="/">
    <xsl:variable name="map" select="parse-json(JSON)?daywisedata?*[last()]" />
    <results>
        <total_cost>
            <xsl:value-of select="$map?total_cost"/>
        </total_cost>
        <total_earning>
            <xsl:value-of select="$map?total_earning"/>
        </total_earning>
    </results>
</xsl:template>

</xsl:stylesheet>

Result

<?xml version="1.0" encoding="UTF-8"?>
<results>
   <total_cost>15</total_cost>
   <total_earning>20</total_earning>
</results>

Demo: xsltfiddle.liberty-development.net/3MXNWNB

Tags