Forum Discussion
Hi nmrao,
1> I will have only 3 rows of xmls and subsequently i will move it to a test database and fetch it from there.
2> Each row in the excel sheet is a test case.
In ready API i am thinking of having as shown in the screenshot attached.
The reason i am having these many test cases is to run all of them in parallel.
Version : Ready API 1.9.0
3> Yes i need to get only those rows whose column "Run" says "Yes".
I was trying this yesterday
Sounds like you may have to use groovy to get the data and parse based on what it says "Yes"
- groovyguy8 years agoCommunity Hero
I think sanj may be on the right idea. You can likely use one Excel DataSource to ingest the Excel file as is. Then you can parse that row by row with a groovy script and either delete rows that do not have "Row = Yes" or copy the rows that do to a new grid datasource.
- Santhosh_P8 years agoContributor
Yes i will have to use groovy.
Also i need to update the endpoints on the fly.
- sanj8 years agoSuper Contributor
I am also working the same thing which is why I was able to point it out!
I am still sorting through the issues!
- Santhosh_P8 years agoContributor
- nmrao8 years agoChampion Level 3Santhosh_P,
Sorry for the delay. Not sure if you are still looking for the answer.
Like I mentioned, I prefere .csv over .xlsx even for data driven tests which is very easy.
Looks like other users (@678, sanj) also looking for the same kind of solution.
Couple of questions.
1. What do you mean by update the endpoints on the fly? You mean to say update the REST request?
2. I do not see any endpoint in the inputDataSheet.xlsx.
3. When you need to read XmlTemplate.xlsx as I do not see that in your Test case diagram.
4. What is the code that you have in groovy script?
Related Content
- 4 years ago
- 6 years ago
- 4 years ago
Recent Discussions
- 10 days ago