Forum Discussion

twozedz's avatar
twozedz
Occasional Contributor
8 years ago
Solved

HI i need to setup datasink using groovyscript

HI I have soapui pro  I have a project with a large number of test cases. Using groovy script i need to add a datasink test step to each test case which will write response values to excel.   ...
twozedz's avatar
twozedz
Occasional Contributor

Sorry i wasnt clear enough before. I have Soap UI Pro

 

 

 

This is what i would like to do using soapui

 

 

1) Pick an XML response file from local drive on my computer.

2) Capture the response file values within the tags.

3) Verify that the response values from XML match to what is in excel sheet that is also locally saved.

4) Loop steps 1-3 for multiple XML responses to their corresponding excel records.

 

I need a dynamic setup for steps 1-4 because the XML file numbers and records in spreadsheet are different for each service. I have multiple services to work with. Each service has its own spreadsheet and its own xml responses.

 

For example:

For service 1: The excel spreadsheet data looks like:

 

Column 1                 Column 2 Column 3 Column 4

 

XML1.XML              John       Jenny     Michael

XML2.XML              Rita        Michel   Mat

XML3.XML             Adam     Betty      Catlin

 

 

The XMl response files for service 1 looks like:

 

Filename: XML1.XML

random tags here

<tag1>John </tag1>

<tag2>Jenny</tag2>

<tag3>Michael</tag3>

random tags here

 

Filename: XML2.XML

random tags here

<tag1>Rita</tag1>

<tag2>Michel</tag2>

<tag3>Mat</tag3>

random tags here

 

Filename: XML3.XML

random tags here

<tag1>Adam</tag1>

<tag2>Betty</tag2>

<tag3>Catlin</tag3>

random tags here

 

Aim: Ensure the values in response match the values in an excel row. Loop that through multiple files against corresponding excel rows. Both XML files and excel are stored locally.

 

I have been trying to figure this out for the last couple of days. Can this be done or am i just wasting my time? if you guys could set me on the right path id really appreciate it.

 

 

 

Thanks

 

 

GillerM's avatar
GillerM
Staff
8 years ago

Thanks for expanding on this.  Here are some configurations that should help:

 

- You can pickup your files with a DataSink type directory: e.g. https://www.soapui.org/docs/data-driven-tests/using-files.html

- Then you can have a nested DataSource type XML where you could walk through repeating tags: e.g. 

http://blog.smartbear.com/api-testing/how-to-use-xml-datasources-for-response-processing-in-soapui/

 

The one setup I'm not 100% on how you should map is the lookup against the Excel.  The way that data is structured with looping through columns will make it hard to be dynamic.  If you had a lightweight database instead of Excel, you could use a JDBC Test Step to do a SQL lookup