HI i need to setup datasink using groovyscript

Question

HI I have soapui pro&nbsp;
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.
&nbsp;
I do not want to manually go and add datasink test step in each test case.&nbsp;
&nbsp;
So where do i start?&nbsp;
&nbsp;
Thanks in Advance.
&nbsp;
&nbsp;

gillerm · Accepted Answer

Thanks for expanding on this. &nbsp;Here are some configurations that should help:
&nbsp;
- You can pickup your files with a DataSink type directory: e.g.&nbsp;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.&nbsp;
http://blog.smartbear.com/api-testing/how-to-use-xml-datasources-for-response-processing-in-soapui/
&nbsp;
The one setup I'm not 100% on how you should map is the lookup against the Excel. &nbsp;The way that data is structured with looping through columns will make it hard to be dynamic. &nbsp;If you had a lightweight database instead of Excel, you could use a JDBC Test Step to do a SQL lookup
&nbsp;
&nbsp;

testhrishi · Answer

Ok, where you planning to add groovi script though?

I guess I am trying to understand the purpose of writing each response to excel before I can suggest something here.

I would recommend using datasink in case of need to produce mass data.

Other than that for automation why would you like you preserve each and every run results every time test runs on top of test logs and results?

twozedz · Answer

Hi testthrishi&nbsp;&nbsp;I need to use the groovyscript in Project1 to clone the datasink step from Project1 into all of the test cases in Project2.&nbsp;Project1TestCase1Teststep1DatasinkGroovyScript&nbsp;&nbsp;Project2TestCase1&nbsp;TestCase2&nbsp;TestCase3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Can this be done? I can hardly see any books online that teach this stuff? DO you know of any good resources? I am good with Java but i just am having trouble with groovyscript syntax for soapui&nbsp;&nbsp;

nmrao · Answer

Good that you mentioned you are familiar with java.

You may use the below javadoc to do the same.

http://www.soapui.org/apidocs/pro/index.html

In fact you can even write a standalone program, read the existing project, add the step where you needed.

twozedz · Answer

Hi yes i am familiar with Java but am no expert. I did it back in Uni and i have no idea how to read that JavaDoc. it doesnt make sense to me.

gillerm · Answer

I'm a little confused about why you try to dynamically clone the DataSink step to three testcases.
&nbsp;
It'll likely take a couple of hours of trial and error coding to create that. &nbsp;Whereas you can configure three datasink steps in a couple of minutes. &nbsp;With that, I'm sure I'm missing something
&nbsp;
Can you please define what is the goal you are trying to achieve?
Are you simply capturing responses? &nbsp;If so, you'd be better off using events rather than datasink groovy cloning.
&nbsp;
If you can describe what functionality you are trying to achieve, we can assist with the setup better. &nbsp;
&nbsp;
Regards,
Mike Giller

Forum Discussion

HI i need to setup datasink using groovyscript

7 Replies

Related Content

Check for empty value in groovyscript

New Domain Setup

ReadyAPI- download a textfile from a URL with groovyscript

ReadyAPI get content of RAWResponse with groovyscript

Zephyr Project Setup

Recent Discussions

Parameterising JDBC Connection Settings..Can you do it?

How to remove (not clear) test case properties from SaveScript

Remove Properties of TestCase from Groovy.

MyFirstPlugin - button Project menu in Ready Api

Integrate ReadyApi with Devops Release pipelines