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
6 years ago
Copy Link
Rao - Should I provide more details on my requirements or it's clear. See above post
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 - Can you suggest right solution for my requirements

    I have data in Excel sheet. Rows can change for each call to the request. Sometimes I get 2 lines and sometimes I get 3 lines.

    I want to ready and pass data from Excel sheet and dynamically created nodes in XML in one message itself

    Message Example

    Header

    ......

    Nodes

    < Item no = ? >
    < Batch number =?>

    Nodes elements should be dynamically added based on number of rows in Excel


    Please advise

    Thanks

    Sameer Kaushik
  • 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