Validating response from test request
Hello. I am looking for a way to make a assertion which will validate my response data with my excel sheet. I have project where i have data source(data from excel) -> test request -> data sink(imp...
Forum Discussion
Hi Martin,
Since you need an assertion which asserts the response you get from an expected response in the excel sheet, you need to read that expected response first from an excel sheet. I would suggest dedicate some columns in your input sheet which is acting as data source for expected results itself, that way, you won't have to declare two different data source steps. Next move the expected results to different properties using a property transfer test step. Once you have these properties set, you can use a groovy assertion or probably xpath assertion to check the response with that of the properties. Your test case should now look like this:
data source(data from excel) -> Property transfer -> Properties -> test request -> data sink(importing data to excel) -> loop.
You don't need to transfer the source properties in your request if you don't need to. You should be able to populate your request still the same way you currently have.
Let me know if this works.
Regards,
Deepesh Jain
Since you need an assertion which asserts the response you get from an expected response in the excel sheet, you need to read that expected response first from an excel sheet. I would suggest dedicate some columns in your input sheet which is acting as data source for expected results itself, that way, you won't have to declare two different data source steps. Next move the expected results to different properties using a property transfer test step. Once you have these properties set, you can use a groovy assertion or probably xpath assertion to check the response with that of the properties. Your test case should now look like this:
data source(data from excel) -> Property transfer -> Properties -> test request -> data sink(importing data to excel) -> loop.
You don't need to transfer the source properties in your request if you don't need to. You should be able to populate your request still the same way you currently have.
Let me know if this works.
Regards,
Deepesh Jain