Validate response against input file which contians data sets for a column

kktulasi404kktulasi404 Posts: 10

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.
Ex:
COL1, COL2, COL3
ABC, XYZ, DFGH, JKJ
FDS, ADS

Comments

  • OmarROmarR Posts: 49 ✭✭

    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....

  • kktulasi404kktulasi404 Posts: 10

    Thank you, I am trying using the Excel sheet itself but I am facing issue at the nested loops

Sign In or Register to comment.