Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.

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

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

  • OmarR
    OmarR Posts: 235 admin

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

  • kktulasi404
    kktulasi404 Posts: 10

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