I am using dataset in VSM and I am trying to get dynamic response for the values present in the excel file. Please suggest me the way to accomplish this.
Scenario - In my webservice XML request, I need to provide employee ID. This given value for employee ID should be searched in the excelsheet, and the corresponding details(Such as Role,Name) should be desplayed in the response
Steps I have done till now:
1. Created a VSM using RR pairs
2. Added a dataset to VSM.
3. Now what should I do, to search the employee ID in the excel sheet and to get the corresponding fields in the response?