Forum Discussion

skaushik9's avatar
skaushik9
Occasional Contributor
6 years ago

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

     

nmrao's avatar
nmrao
Champion Level 3
6 years ago
You may need to change the approach.
What purpose it is solving to have excel? Instead why can't you have desired request in the request itself?
  • skaushik9's avatar
    skaushik9
    Occasional Contributor
    6 years ago
    Thanks for picking this up.

    As my number of lines may be different in each request for example it may be 3 or 4 or 6 etc so I am using Excel to pass data to request instead of creating XML elements based on data and hardcoding them with parameters.

    Thanks

    • skaushik9's avatar
      skaushik9
      Occasional Contributor
      6 years ago
      Rao - Should I provide more details on my requirements or it's clear. See above post
      • nmrao's avatar
        nmrao
        Champion Level 3
        6 years ago
        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?