AnsweredAssumed Answered

Getting dynamic response for the values present in the excel file

Question asked by Aldin on Sep 28, 2015
Latest reply on Sep 6, 2018 by Jeeruc3

Hi,

 

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.

 

Also please help me with the sample piece of code, If i need to use JavaScript Step.

 

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?


Outcomes