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...
skaushik9's avatar
skaushik9
Occasional Contributor
6 years ago
Copy Link
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
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