New to SoapUI

Question

I am new to SoapUI (v5.5) but I did, in a regular basis, send XML requests from my laptop to other systems via SoapUI. Our vendors supplied me with the WSDL as well as the actual requests.

Is there any way SoapUI can read a data file in my laptop and sends the same XML request to an external system one by one? More specifically, there are only one variable in the XML request and I have to send this request to update multiple records in an external table. So, one variable, same request to one destination.

Sorry if I am not using the right terminologies. I think the proper terminology for variables is “property”.

richie · Answer

Hey Mis3,So,i just want to be clear....i tend to get confused easily so its easier to just clarify everything up front.Question1. You have some multiple testdata records helds in either a single file or multiple files (one record in each testdata file) on your laptop. Is that right?Question2. You have a single api endpoint which you want to send the content in these testdata files. Is that right?Question3. Youve been given a wsdl file to help you setup the required tests. Is that right?Question4. You mention a wsdl, so this is a SOAP request. Is that right?Question5. The content of your testdata defined records. Is it whole xml instances (which youve been told is the payload for you SOAP requests) or have you just got a list of attribute values in your testdata that has been mapped to xml tags within a predefined payload?Question6.  What level of setup and automation is required?  Do you want a single testcase to loop through your testdata (which requires groovyscript) or is it acceptable for individual testcases, 1 testcase for each testdata permutation defined? Cheers,Rich

mis3 · Answer

Apology of being confusing.&nbsp; I am sure I am not using the right terminologies.&nbsp;Question1. You have some multiple testdata records helds in either a single file or multiple files (one record in each testdata file) on your laptop. Is that right?[MIS3]Yes.&nbsp; In my SoapUI, I have multiple API calls (XML scripts) to update tables in several external systems.&nbsp; &nbsp; Each API has it own endpoint.&nbsp; If there is a project which I have to update more than one external system, I would execute the XML scripts one after the other.&nbsp;&nbsp;For now, I have a project which I have to send the same XML script to the same endpoint 1,000 times with only one variable (subscriber-ID).&nbsp; I am hoping there is a way so SoapUI will read a external file and sends the XML request 1,000 times.&nbsp;Question2. You have a single api endpoint which you want to send the content in these testdata files. Is that right?[MIS3]&nbsp; Yes, one single endpoint in this new project.Question3. Youve been given a wsdl file to help you setup the required tests. Is that right?[MIS3]&nbsp;&nbsp;This is what I did.&nbsp; I created a new project in SoapUI, then enter the wsdl.&nbsp; SoapUI will then create all the API calls under this project.&nbsp; I would see a lot of "Request 1" in each API.&nbsp; &nbsp;I would modify the Request 1 for my purpose.All these calls (mostly XML but a few are in JSONS) are working.Question4. You mention a wsdl, so this is a SOAP request. Is that right?[MIS3]&nbsp; I think so.&nbsp; &nbsp;Please refer to my response of Question3 above.Question5. The content of your testdata defined records. Is it whole xml instances (which youve been told is the payload for you SOAP requests) or have you just got a list of attribute values in your testdata that has been mapped to xml tags within a predefined payload?[MIS3]&nbsp;Not sure what is an instance.&nbsp; If you are referring to the payload (XML script), they are all working.&nbsp; I would just replace the variable (in this case, subscriber-ID) and click Send.&nbsp;&nbsp;Question6. What level of setup and automation is required? Do you want a single testcase to loop through your testdata (which requires groovyscript) or is it acceptable for individual testcases, 1 testcase for each testdata permutation defined?[MIS3]&nbsp; Yes, a single testcase to loop through my testdata.&nbsp;&nbsp;If there are 5 records I have to update, I would execute the XML script 5 times.&nbsp; However, this time I have to update 1000 records, so, I am hoping that there is a way (a loop) to do this more efficiently.I will research on Groovyscript.&nbsp; Is there any online tutorial for this?&nbsp;

richie · Answer

Hey Mis3,Ok. So you have a single file with subscriberIds that need to be passed to a subscriberId element in the SOAPBody of your SOAP test step in a looping test to inject each request until all the subscriberId values have been used, right?If youre brand new to soapui and dont have any coding experience the following link is probably the easiest way of doing what you need i have found. Personally i always use csv's as the datafile rather than a spreadsheet as it adds extra complication.Anyway. Check out this link.http://roadtoautomation.blogspot.com/2013/08/road-to-data-driven-testing-in-soapui.html?m=1Youll need two test steps in your testcase. First one will be a groovyscript test step. Second teststep will the your SOAP test step.I'm typing this out on my phone so please forgive the lack of formatting. Taking the detail supplied in the linked webpage and the detail youve indicated, im guessing your code will need to look like the following:def groovyUtils = new com.eviware.soapui.support.GroovyUtils(context)def csvFilePath = "D:\URL.csv"context.fileReader = new BufferedReader(new FileReader(csvFilePath))rowsData = context.fileReader.readLines()int rowsize = rowsData.size()for(int i =0; I &lt; rowsize; i++){rowdata = rowsData[i]String[] data = rowdata.split(",")log.info data[1]groovyUtils.setPropertyValue("SOAPTestStepName", "SubscriberId", data[0])testRunner.runTestStepByName( "SOAPTestStepName")}In your SOAP teststep where your subscriberId value should go, insert the value ${subscriberIdValue}, so the subscriberId element in your SOAPBody looks like:&lt;SUBSCRIBERID&gt;${subscriberIdValue}&lt;/SUBSCRIBERID&gt;Ok. I think thats all you need to do. Follow those instructions and i think youre sorted.Cheers!Rich

mis3 · Answer

Thanks, Ritchie.&nbsp; &nbsp;This is GREAT HELP; I have something to start with!&nbsp;I can see that the statement associates the 1st data field to&nbsp;SubscriberId:groovyUtils.setPropertyValue("SOAPTestStepName", "SubscriberId", data[0])&nbsp;How do you associate&nbsp;SubscriberId to this subscriberIdValue?&lt;SUBSCRIBERID&gt;${subscriberIdValue}&lt;/SUBSCRIBERID&gt;&nbsp;Also, how about the type of property like Project level, Testsuite level, testcase level?&nbsp; Like ${#TestSuite#SubscriberId}&nbsp;&nbsp;

richie · Answer

Hry Mis3,Sorry i made a mistake...proving i really shouldnt be trying to do this on my phone!Anyway.  The script should work if you have a single file (csv) and a new subscriberId value comma separated one on each row.Where the code says "groovyUtils.setPropertyValue("SOAPTestStepName", "SubscriberId", data[0])"  change "SubscriberId" to "subscriberIdValue" so it reads as follows:"groovyUtils.setPropertyValue("SOAPTestStepName", "subscriberIdValue", data[0])"This will treat every single value in your csv file as a value associated with the "subscriberIdValue" property.As i state in my previous message if you edit the value in the payload that corresponds to the "subscriberIdValue" property value....e.g.&lt;SUBSCRIBERID&gt;${subscriberIdValue}&lt;/SUBSCRIBERID&gt;This links the values in your csv to the subscriberIdValue property to the &lt;/SUBSCRIBERID&gt; element's value in your payload.  The whole thing should work now.Right, next thing.  You ask about saving off the property to a different scope/level ....either project, testsuite, testcase, or in a properties step.  Yes you can do this with some slight alterations to the setProperty line in the code.  However, why would you want to do this in this case.  What youre talking about is if you want to save the property for some other use.  However, why would you want to for what you need?  Also this is a looping testcase remember if you saved off the property values against project, testsuite, or testcase, these would be overwritten each loop of your testcase.TaRich

Forum Discussion

New to SoapUI

Related Content

SoapUI 5.5.0 Log4j vulnerability

recommended upgrade process for SoapUI

SoapUI 5.6 vs. Log4j

soapUI startup crash

SoapUI compilation

Recent Discussions

How to return the results or log files, from the testrunner.bat command line

Error

If you close the window after installation, the application freezes and becomes unusable.

GraphQL schema loading

No Fluff Just Real Stuff - Issue #2 from the DevRel Team at SmartBear