Forum Discussion

kunalmalviya's avatar
kunalmalviya
Occasional Contributor
9 years ago

Execute test cases from excel based on Yes/No flag?

First step in my test cases is a excel data source which has different combination of parameters that get supplied to my REST request. I want to execute my test only for those rows which are marked a...
  • JKambli's avatar
    JKambli
    9 years ago

    Add a groovy script after DataSource

     

    Right click > Get Data> DataSource > Execute

     

    if (valueOfExecute == 'Yes'){

    testRunner.gotoStepByName( "next step name")

    }

    else

    {

    testRunner.gotoStepByName( "DataSource Loop")

    }

     

    Thanks

kunalmalviya's avatar
kunalmalviya
Occasional Contributor

Sorry for the confusion.

 

Here is how my structure looks in SoapUI

 

--TestSuite

     - TestCase1

         - TestStep1 (Excel datasource)

         - TestStep2 (REST Request)

         - TestStep3 (DataSource Loop)

 

In my 1st step the data from excel looks like this where zip and sessionid gets passed to REST request

 

Execute |   Zip    | SessionID

   Yes     | 12345  |  1

    Yes    |  42156 |  2

    No     |  25478 |  3

 

Now I only want to pass these parameters when the flag is set to "Yes" or else Skip.

JKambli's avatar
JKambli
Staff
9 years ago

Add a groovy script after DataSource

 

Right click > Get Data> DataSource > Execute

 

if (valueOfExecute == 'Yes'){

testRunner.gotoStepByName( "next step name")

}

else

{

testRunner.gotoStepByName( "DataSource Loop")

}

 

Thanks