Forum Discussion

Mike_M's avatar
Mike_M
New Contributor
17 years ago

Using multiple rows of a Data Source in a single TestRequest step

Does anyone know of a relatively simple way to consume multiple rows of a Datasource in one Test Request step? The scenario here being able to combine multiple rows in a worksheet into a single bat...
Mike_M's avatar
Mike_M
New Contributor
17 years ago
Thanks again.

I ended up turning the rows of data into XML in a Groovy step, but I assigned it to a property, then used property expansion to place the relevant data in the request (see below.)

What I should do is read the list of properties from the DataSource and build the XML generically.

Groovy script:

def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context )
def dataSource = testRunner.testCase.testSteps['DataSource']

def xml = ''
while( dataSource.next( testRunner, context ) )
{
    xml += ''
    xml += '' + groovyUtils.expand('${DataSource#OrderID}') + ''
    xml += '' + groovyUtils.expand('${DataSource#OrderName}') + ''
    xml += ''
}
xml += ''

groovyUtils.setPropertyValue("Properties","xml", xml)


Request fragment:


 
    ${Properties#xml#//dataRow[1]/OrderID/text()}
    ${Properties#xml#//dataRow[1]/Name/text()}
 
 
    ${Properties#xml#//dataRow[2]/OrderID/text()}
    ${Properties#xml#//dataRow[2]/Name/text()}