Forum Discussion

Gkm's avatar
Gkm
Contributor
9 years ago
Solved

How to get values from CDATA of JDBC request and compare it with Json Response

My JDBC request:   <Results> <ResultSet fetchSize="1288"> <Row rowNumber="1"> <ConfigurationXML><![CDATA[<ROOT><StartDistance>0</StartDistance><Device>[{"Name":"CAM 1 ","Profile":{"ID"...
JKambli's avatar
JKambli
Icon for Staff rankStaff
9 years ago

We do have a script but it doesn't reflect changes on UI,

Open the Project window, select the "Events" tab and add a RequestFilter.afterRequest handler. Set its content to:

 

def content = context.httpResponse.responseContent
content = content.replaceAll( "<!\\[CDATA\\[", "" )
content = content.replaceAll( "]]>", "" )

//log.info( content )

context.httpResponse.responseContent = content

If you add this you can use property expansion with JDBC.