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 case, data source takes multiple rows from the Excel file. It loops each row and generates separate XML file for each row. For example

Message 1 for first row in Excel

Header XML elements
<......>
Child XML elements

Ship no 1
Qty 1
Batch number 001

Message 2 for second row in Excel

Header XML elements

Child XML elements

Ship no 2
Qty 5
Batch number 002

_-----------++++++----------

What I want is

Message

Header XML elements

Child XML elements

Ship no 1
Qty 1
Batch number 001

Ship no 2
Qty 5
Batch number 002
  • 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

     

8 Replies

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