Forum Discussion

skaushik9's avatar
skaushik9
Occasional Contributor
6 years ago
Solved

URGENT- SOAPUI- Dynamical XML for creating elements

Hi, I have a below structure in my Test case Note - I am using Soapui PRO 1) Data source - reading multiple rows from Excel file 2) Request method 3) Data source loop When I run the test ca...
nmrao's avatar
nmrao
Icon for Champion Level 2 rankChampion Level 2
6 years ago
Copy Link
But the way you have the data is not allowing you to achieve what you are looking for. Then what is the use of data source which you currently have?
skaushik9's avatar
skaushik9
Occasional Contributor
6 years ago
Copy Link
Rao - Please advise the solution for my requirements.

I need to read data from Excel and then create child XML nodes based on number of rows in Excel which will be dynamic
  • skaushik9's avatar
    skaushik9
    Occasional Contributor
    6 years ago
    Copy Link
    Rao - Any update or advice you can provide on above

    Sameer Kaushik
    • Nastya_Khovrina's avatar
      Nastya_Khovrina
      Icon for Alumni rankAlumni
      6 years ago
      Copy Link

      Hi skaushik9,

       

      The DataSource Loop isn't helpful here. If you use it the request is sent each time when you iterate through rows.

       

      You can do the following:

      1. Continue using the Excel file as a source, but use a Groovy script to read the data from it. 

      2. Store the data in the XML file. In this case, you will be able to use the DataSource of the Directory (xml) or File (txt) type to read all the content and write to one property.

      Please see the screenshots: 

       

      DataSource - Directory

      DataSource - File