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 - Same Excelfile - sheet A properties
2 datasource - Same Excelfile - sheet B properties
1 rest request
Sometimes
{
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)
]
}