Issue with XSLT converted xml file size

[former_member764649]

Hi Everyone ,

In My requirement after we receive xml response using http request reply adapter , we used XSLT mapping to extract the required fields for target and then used XML to JSON converter to convert it to JSON .

But the original response xml file size is 2 MB , after XSLT mapping the size become 130MB

Could you please tell how we can over come this .

Rceeived Response and XSLT mapping both attached here . In response "m:properties" values will appear more than 1 times .

response-1631789728597-1.xml

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" exclude-result-prefixes="d m">
    <xsl:output method="xml" indent="yes" omit-xml-declaration="yes"/>
    <xsl:strip-space elements="*"/>
    <xsl:template match="/">
        <xsl:apply-templates select="//m:properties"/>
    </xsl:template>
    <xsl:template match="m:properties">        
            <xsl:for-each select="//m:properties">
                <Record>
                    <ProductId>
                        <xsl:value-of select="d:ProductId"/>
                    </ProductId>
                    <LocationId>
                        <xsl:value-of select="d:LocationId"/>
                    </LocationId>
                    <ForecastDate>
                        <xsl:value-of select="d:ForecastDate"/>
                    </ForecastDate>
                    <StartTime>
                        <xsl:value-of select="d:StartTime"/>
                    </StartTime>
                    <EndTime>
                        <xsl:value-of select="d:EndTime"/>
                    </EndTime>
                    <ForecastValue>
                        <xsl:value-of select="d:ForecastValue"/>
                    </ForecastValue>
                </Record>
            </xsl:for-each>
        
    </xsl:template>
</xsl:stylesheet>

[former_member226]

Strange...Could it be due to some looping process or splitter that you are using which iterates over the input body n number of times? Is it possible for you to share a snap of the iflow?

Because, honestly, I see no reason why a 2MB message will suddenly become a 130 MB message after XSLT mapping.

[former_member764649]

In My Ifow no iteration has been used.