I have the following requirement to be implemented in my project. Kindly help me in giving the best solution.
I want to do this activity in DevTest workstation. Kindly share your thoughts on this.
I am afraid that you need to do this in the portal (as documented here Create Data-Driven Virtual Services - DevTest Solutions - 10.2 - CA Technologies Documentation.
Thank you wooda20
My question is ... Can't we do the same from the workstation ?
As I said, I am afraid that you need to do this in the portal.
So not in the workstation.
Hi kokumar4 ,
I believe you can easily do this through Third party Jars using Apache POI classes . Apache POI classes are used to read/Write excel file . Hence once you are able to read file you can compare the same with your input property and further Parent account id can be fetched . Since only one incoming account id is there you can traverse the sheet using that Account id column and if it matches then you can fetch Parent id and return true that will stop the script .
Data Driven approach is completely different and enhanced and simplified as well . But before that above concept was used . Let me know if any other information is required .
Refer below two for implementation .
Writing Response to Excel File - LOG Utility
Read Write From Excel File