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...
  • Nastya_Khovrina's avatar
    Nastya_Khovrina
    6 years ago

    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

     

skaushik9's avatar
skaushik9
Occasional Contributor
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
Rao - Any update or advice you can provide on above

Sameer Kaushik
  • Nastya_Khovrina's avatar
    Nastya_Khovrina
    SmartBear Alumni (Retired)
    6 years ago

    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