SOATest: Use of datasource column names in the XPath editor
I have the below JSON response where I need to assert the statusCode for a particular name and this name is getting fetched from the 'name' column in the excel sheet used as a datasource.
"statusName": "Pending Approval",
For this one when I used a JSON Assertor and added a Value Assertion for the statusCode element and using XPath changed the element to as below:
Clicked on Evaluate XPath and it showed the right status in the Result section.
But my question is-Is there a way I can change the above XPath query to use the column name ('name') from the excelsheet(datasource) instead of using 'test1'.
For ex something like as below:
Any help is much appreciated!