Forum Discussion

ario's avatar
ario
New Contributor
8 years ago

Load records from Datasource[Excel] into SOAP Request as multiple XML nodes

Hi,   So I have an excel file with 2 rows of person names.   person_name John Smith Linda Howard I have loaded the excel file into DataSource, but then   I wanted to load the result into the S...
Radford's avatar
Radford
Super Contributor

There are a few ways, and you shouldn't need to resort to Groovy Script. Two of the simple built in methods are:

 

  1. Use the Point and Click Get Data functionality from within your SOAP request to reference the Data Source properties.
  2. Put a Property Transfer test step between your two test steps and configure appropriate to your needs to transfer your data.

 

 

 

 

ario's avatar
ario
New Contributor
8 years ago

Hi,

 

Thank you for your reply, I think your solution will work if only the XML already had 2 nodes. Please correct me if I'm wrong?

 

Sorry for being not clear, so my question is how to create a dynamic nodes the XML based on the datasource[excel] records?

 

So, in the excel I've got:

person_name
John Smith
Linda Howard
Joe Bloggs

My current SOAP UI XML is below:

<xml>
<persons>
<person>
</person>
</persons>
</xml>

I wanted the end result to look like below:

<xml>
<persons>
<person>John Smith</person>
<person>Linda Howard</person>
<person>Joe Bloggs</person>
</persons>
</xml>

 

 

Then finally to trigger the 'updated' XML request