Solved
Forum Discussion
Rao - Should I provide more details on my requirements or it's clear. See above post
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?
- 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 - 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- Rao - Any update or advice you can provide on above
Sameer Kaushik- Nastya_Khovrina6 years ago
Alumni
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