Service Virtualization

I have virtualised SOAP service using Request and response pair. I would like to implement data driven approach and the condition is based on the input provided in the request, values should be retrieved from different tabs in a excel sheet.One attribute can act as primay key in all the tabs in the excel sheet.Can someone please let me know the best way to implement this scenario.

DevTest version:10.1.0

Since you are using excel sheet and you want to lookup the value in different tabs on the basis of input, can only be achieve by scripting. Do write a java script step for the same.

Or you can use a database with different tables, just write a sql query and use the result in you response.

Hi Monika,

Thanks for your response

It would be really helpful if you can share any sample javascript if available

Hi,

    Try this approach How to read content from different excel sheet from same excel workbook? 

Thanks,

Vish