Forum Discussion

Premier2k's avatar
Premier2k
Occasional Contributor
9 years ago

Looping through a resultset

Hi all,   I'm trying to loop through a result set and add the results to a map, I have done this already with some JSON output and I'm trying to do the same for the database resultset but it's only...
Premier2k's avatar
Premier2k
Occasional Contributor

Sure, I've attached the response I'm getting back from my DB call.

nmrao's avatar
nmrao
Champion Level 3
9 years ago
But this is not json in the first place.

So what data you want ?
  • Premier2k's avatar
    Premier2k
    Occasional Contributor
    9 years ago

    Correct, the JSON output is being handled correctly, that is the gatewayMap. I'm trying to add the DB response to the stagingMap but it only outputs the first row

    • nmrao's avatar
      nmrao
      Champion Level 3
      9 years ago

      Please use the below script to get the Row data into map as shown below. Pass your xml string as input

       

      import groovy.xml.*
//pass xml string as input
def results = new XmlSlurper().parseText(xml)
def map = [:]
results.ResultSet.Row.each { 
 map[it.EXPENDITUREAMOUNT] = it.EXPENDITURETYPE 
​}
log.info map​

       

       

      • Premier2k's avatar
        Premier2k
        Occasional Contributor
        9 years ago

        So I've implemented this like below but when I run it, nothing happens, it's just constantly 'running'...

         

        def groovyUtils = new com.eviware.soapui.support.GroovyUtils(context)
import com.eviware.soapui.support.XmlHolder
import groovy.json.*
import groovy.xml.*

def responseJSON = testRunner.testCase.testSteps["Retrieve case data from GW"].testRequest.response.responseContent

def response = new JsonSlurper().parseText(responseJSON)
def responseXML = new XmlHolder (testRunner.testCase.testSteps["Retrieve household data from staging"].testRequest.response.responseContent)
def results = new XmlSlurper().parseText(responseXML)

def stagingMap = [:]
		results.ResultSet.Row.each { 
 	map[it.EXPENDITUREAMOUNT] = it.EXPENDITURETYPE }

        Nothing gets output from log.info as it appears to be just constantly running.