Need to validate the REST API output with an input Excel file where it has few columns and one column is a data set itself.
COL1, COL2, COL3
ABC, XYZ, DFGH, JKJ
Hey Mr. 404,
What is your current progress/hurdle with this scenario? There are many ways to accomplish this.
You can try the following:
1) Create an Excel-datasource and point to your desired Excel spreadsheet
2) Chain an XML/JSON databank to your client to extract the desired Output
3) Use an XML/JSON assertor to compare the values extracted
Give this a shot and see where it takes yooooouuu....
Thank you, I am trying using the Excel sheet itself but I am facing issue at the nested loops