Nested datasourceloop
Hello Everyone
I have a POST Request to send and it has nested loop
{
xyz:value
abc:value [
{
pqr:value
qaz:value
}
]
}
Excelfile has 2 worksheets - Sheet A and Sheet B
1. Sheet A has values of xyz, abc
2. Sheet B has values of pqr, qaz - this section loops but sometimes 1, sometimes 2 and sometimes 3 depends on sheet A
3. Both files are linked with ID for our reference
Example Concept: IF
Sheet A - ID1 - has 1 row
Sheet B - ID1 - has 3 rows
then the req sent will be
Request:
{
xyz:value
abc:value [
{
pqr:value1
qaz:value1
},
{
pqr:value2
qaz:value2
},
{
pqr:value3
qaz:value3
}
]
}
Response:
Has 1 output that is in the sheet A for comparision.
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.