cancel
Showing results for 
Search instead for 
Did you mean: 

data source query

SOLVED
Occasional Contributor

data source query

I am Licensed user of SoapUI Pro. My query is regarding data driven testing.

I have WSDL that register member based on unique values of three fields. Repeated values will not register and give error from system. For each run, I have to enter unique data each time. How to do this in SoapUI so that in each iteration new set of values should be picked from data source?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Hero

Re: data source query

Hmm. limitations.

See if the helps

<element>${= System.currentTimeMillis()}</element>


Regards,
Rao.

View solution in original post

8 REPLIES 8
Community Hero

Re: data source query

Hey @Nancy2,

 

Welcome to the SmartBear community!

 

Can you please explain your test scenario a little bit more? How is the data source generated? Is it an excel file? Do you generate it by using a script? Or is it that you want to generate it and you don't know how?



If my answer helped please click on the 'Accept as Solution' button.
Occasional Contributor

Re: data source query

1. How is the data source generated? Is it an excel file? _ Yes data source is created manually in excel file and linked

2. Do you generate it by using a script?  - No

3. Or is it that you want to generate it and you don't know how? _ know how to generate

4. Can you please explain your test scenario a little bit more? - OK first Ill explain my scenario -

My WSDL has few input parameters and three of the input parameters has to be unique. For example to register Fits Name, last name and email address has to be pass unique each time to register else WSDL will show Duplicate record message. Now the scenario is, while each execution run, unique data has to be passed. When I run this test case manually I can chnage the data and member gets registered and based on new registeration I run further test cases in test suite. 

Now, the query is that I want SoapUI to understand and pick unique data each time and register member successfully. Can you suggest me how to do such case?

 

Community Hero

Re: data source query

@Nancy2,
UUID can be used which will be unique each time. And does not require any data source as well.

For example,
<FirstName>${= UUID.randomUUID()}</FirstName>

Similarly other values can be populated too.


Regards,
Rao.
Occasional Contributor

Re: data source query

Hi,

 

Thanks for the reply.

 

This solution is not working as column length is specific and the random value that is being generated is going beyond the specified length, so throw error message while execution - Input value length exceeds for one of the parameters.

 

Regards,

PB

Community Hero

Re: data source query

Hmm. limitations.

See if the helps

<element>${= System.currentTimeMillis()}</element>


Regards,
Rao.

View solution in original post

Occasional Contributor

Re: data source query

Hi Rao,

 

Technically this worked.

 

Thank you so much. Highly appreciated.

 

Regards,

Preeti

Community Hero

Re: data source query

Appreciate if you accept that answer as solution.


Regards,
Rao.
Community Hero

Re: data source query

@Nancy2 

 

as @Rao said there's other options to do the same thing - I tend to use '${=(new Date().format('dd-MM-yyyy'))' to suffix my request Ids. 

This inserts the current date - so as long as you only run the tests once a day - this will do the job - I'm sure you can extend this so it supports time too (although I've never tried) if you wanted to run the tests >once per day

 

cheers,

 

richie

if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the title of the post to something more descriptive? This will help people when searching for problems.
New Here?
Join us and watch the welcome video:
Top Kudoed Authors