repeating elements when using xls datasource?

Question

Hi,Is it possible using a spreadsheet to test the cardinality of the repeating element? For example, one of our elements has a repeating child element:...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  ?&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  ...I would like to generate the requests belowScenario 1:...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  ...Scenario 2:...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Prod1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  ...Scenario 3:...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Prod1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Prod2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  ...Is this possible using a spreadsheet or should I be considering a file datasource with the different xml requests needed?&nbsp; We have to run about 1000 scenarios (and some of our messages will have hundreds of elements per message) so I'd rather&nbsp; maintain a spreadsheet than 1000 xml files. thanks for your advice..Garret

omatzura · Answer

Hi Garret,hmm.. is the number of CustomerOrderItem elements fixed or can it change for each request?- If it's fixed, you could create a groovy script that assigns the values - If it's dynamic, the groovy script would also have to create the xml for each item and then insert the whole block into the requestregards,/Oleeviware.com

cdunne · Answer

Hi Ole,In the live environment the number of elements will change per request. In testing it would be sufficient if we always test 2 elements.How would you suggest we arrange our spreadsheet &amp; groovy script? Is it possible to have the main request fields in one worksheet, then reference another worksheet per repeatable element perhaps?

omatzura · Answer

Hi,hmm.. if you want to add all rows in your datasource to one request you could do as follows:1) DataSource2) Groovy script that aggregates and builds xml 3) DataSourceLoop back to (2) for each row in (1)4) Request that uses aggregated xmlThe key here obviously being the script in (2), something like// get existing..def xml = context.xmlif( xml == null )&nbsp; xml = ""// aggregate rowxml += "&lt;CustomerOrderItem&gt;&lt;Id&gt;" xml += context.expand( "${DataSource#id}"&nbsp; )xml += "&lt;/Id&gt;&lt;Name&gt;"xml += context.expand( "${DataSource#name}"&nbsp; )xml += "&lt;/Name&gt;&lt;/CustomerOrderItem&gt;"// savecontext.xml = xmlIn your request you could then have the following xml: &lt;CustomerOrder&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  ${xml}&lt;/CustomerOrder&gt;makes sense?regards!/Oleeviware.com

cdunne · Answer

Understood Ole,Thank you..Garret

Forum Discussion

repeating elements when using xls datasource?

Recent Discussions

Endpoint forwarding and routing issue in ReadyAPI, with ReadyAPI SV version 3.58.0.

Data Sink JDBC doesn't register connection properties

Windows installation <user>

Related Content

How to map repeating elements from xml response to datasink

DataSource Loop with variable number of child elements

Repeating test steps