Dears,

Am getting below output from SQL Datasource:

<sql result="success">

<parameter position="1" isNull="true"/>

<parameter position="7">{"name":"dan","Surname":""}</parameter>

</sql>

My Expected output is json only:

{

"name":"dan",

"Surname":""

}

please suggest how can i extract json.

With this XPath:

string(/sql/parameter[="7"])

Dear Hermann,

I am able to log the data now in error logs using below XSLT

<xsl:template match="/">

<xsl:variable name = "out"><xsl:value-of select="string(/db-results/sql/parameter[='7'])"/></xsl:variable>

<xsl:message dp:type="all" dp:priority="error"><xsl:value-of select="string(/db-results/sql/parameter[='7'])"/></xsl:message>

is it possible to print the json output in soapui, can you please help,

i tried to set variable (json data)in header in xslt only and then i tried to read from gatewayscript its working but my arabic data is getting changed in output.

can you help me to print the data in output immediately after XSLT...

Dear

Please update