Nested datasourceloop

Question

Hello EveryoneI have a POST Request to send and it has nested loop{&nbsp; &nbsp; &nbsp; &nbsp;xyz:value&nbsp; &nbsp; &nbsp; &nbsp;abc:value [&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; pqr:value&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; qaz:value&nbsp; &nbsp; &nbsp; }]}Excelfile has 2 worksheets - Sheet A and Sheet B1. Sheet A has values of xyz, abc2. Sheet B has values of pqr, qaz - this section loops but sometimes 1, sometimes 2 and sometimes 3 depends on sheet A3. Both files are linked with ID for our referenceExample Concept: IFSheet A - ID1 - has 1 rowSheet B - ID1 - has 3 rows&nbsp;then the req sent will beRequest:{&nbsp; &nbsp; &nbsp; &nbsp;xyz:value&nbsp; &nbsp; &nbsp; &nbsp;abc:value [&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; pqr:value1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; qaz:value1&nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp;{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; pqr:value2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; qaz:value2&nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp;{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; pqr:value3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; qaz:value3&nbsp; &nbsp; &nbsp; }]}&nbsp;Response:Has 1 output that is in the sheet A for comparision.&nbsp;I got to know that we have to write groovy script, but have no idea how to write.Can someone please write here in detail?Or any other way to approach.Thank you in advance.

sarahs · Answer

If you're using ReadyAPI Test you should be able to set this up fairly easy by using Data Source test steps and Data Source Loops. I've added in a screenshot that shows a sample structure on how this would be implemented.

&nbsp;

nehaladani · Answer

Hello Saras,&nbsp;Thank you for your reply..Can you please explain in words, how to do it.?Thank you!

sarahs · Answer

This is all done with the Data Source test step and the Data Source Loop test step.
All that is required is adding one data source and loop for each set of data you want to use.
Once the steps are added to your test case you can click and drag the steps to in the test case interface to place where the data is used.

Setting up the data sources and loops are fairly simple. You can refer to the documentation here for help getting these set up.
Data Source: https://support.smartbear.com/readyapi/docs/functional/steps/data-source.html
Data Source Loop: https://support.smartbear.com/readyapi/docs/functional/steps/data-source-loop.html

nehaladani · Answer

Thank you SarahS,But, I know how to link datasource with readyAPI and to the rest request but the question is how to loop it for my requirement of having 2 worksheets in one excel file.1 datasource&nbsp; -&nbsp; Same Excelfile&nbsp; - sheet A properties2 datasource - Same Excelfile - sheet B properties1 rest requestSometimes{Sheet A - id1[Sheet B (variable number of loops, id1- 1, 2, 3 row from sheet B)]}Sometimes{sheet A - id2[Sheet B (variable number of loops, id2- 4, 5 row from sheet B)]}Sometimes{sheet A - id3[Sheet B (variable number of loops, id3- 6, 7 row from sheet B)]}Sometimes{sheet A - id4[Sheet B (variable number of loops, id4- 8, 9, 10 row from sheet B)]}

Forum Discussion

Nested datasourceloop

Related Content

java.io.IOException: UT010029: Stream is closed on DataSourceLoop

TestComplete cannot find nested Popup menu, In neste popup menu.

nested if-statemenet

Defining Nested Data in Response Schema

Nested if then's

Recent Discussions

Accessing database connection string from groovy test step

Assert Step Not Executing All Assertions

Include external files (XML) for JDBC connection

JDBC database connection pooling

JDBC "Some connection settings are not specified"