Forum Discussion

Emric-Test's avatar
Emric-Test
Occasional Contributor
17 years ago

Saving entire response in database/excel

Hi! I'm, new to this, so please be patient. I'm trying to create a mockup service, but before doing so I'd like to get some replies from the existing webservice and store in a database, so I later...
omatzura's avatar
omatzura
Super Contributor
17 years ago
Hi!

sorry for the delay.. please try the following in your MockResponse script:


import groovy.sql.Sql

def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context )
def holder = groovyUtils.getXmlHolder(  mockRequest.requestContent )
def objectRefIn=holder["//ucor:object/text()"]

sql = Sql.newInstance("jdbc:jtds:sqlserver://CWS-Fredrik_C/uc_resp;domain=", "soapUI","soapUI", "net.sourceforge.jtds.jdbc.Driver")
def row=sql.firstRow("select UCresponse from resp where socid ={objectRefIn}")

mockResponse.setResponseContent("${row.UCresponse}")


Hope this helps!

regards,

/Ole
eviware.com