Forum Discussion

roja1's avatar
roja1
Contributor
6 years ago

compare property names with data in excel file

Hi,   I want to get the property name from properties at test step level. I have an excel which has 1st column as property names and 2nd value as property value. The property name which I get from ...
  • avidCoder's avatar
    avidCoder
    6 years ago

    Then you can get the list of properties present inside the Properties TestStep and then compare :-

    def testStep = testRunner.testCase.testSteps["Properties"]
if (testStep.getPropertyCount() > 0){
 for (prop in testStep.getPropertyList()){
  log.info(prop.getName() +" "+ prop.getValue())
 }
}
  • roja1's avatar
    roja1
    6 years ago

    Hi,

     

    Thank you. It helped me to get the properties.

  • avidCoder's avatar
    avidCoder
    6 years ago

    Ok, you are getting error at line 20. Actually setPropertyValue("", Val) always accepts String. Try to store prop.getName to a String value and then pass there. Like this - 

     

    def testStep = testRunner.testCase.testSteps["Properties"]
if (testStep.getPropertyCount() > 0){
for (prop in testStep.getPropertyList()){
for(int i=0;i<size;i++){
Cell f=sheet1.getCell(0,i)
field=f.getContents()
Cell f1=sheet1.getCell(1,i)
value=f1.getContents()
String propName = prop.getName()
log.info propName
if(prop.getName()==field){
testRunner.testCase.testSteps["Properties"].setPropertyValue(propName, value)
}
else{
log.info "Not Found"
}
}
}
}
avidCoder's avatar
avidCoder
Super Contributor
6 years ago

First, get the properties value from test Steps using this code :-

 

def code = testRunner.testCase.testSteps['Properties'].getPropertyValue("Code")

Where, Code is the property name in Properties Step.

And after that, Use DataSource expansion code

def code = context.expand( '${DataSource#Code}' )

Where, code is the column in Excel.

 

And, if you are not using paid version of soapui, then you need to write excel connection code using java/groovy and fetch the particular row and column value and then do assert logic.

And, finally,  do assertEquals logic,

  • roja1's avatar
    roja1
    Contributor
    6 years ago

    Hi,

    Thanks for the response.

    What I am trying to acheive is , suppose my properties step has 4 properties named a,b,c,d. I want to get the names of those properties and serach for their values which are already present in an excel file.

     

    Appreciate your help in advance.

    • avidCoder's avatar
      avidCoder
      Super Contributor
      6 years ago

      Then you can get the list of properties present inside the Properties TestStep and then compare :-

      def testStep = testRunner.testCase.testSteps["Properties"]
if (testStep.getPropertyCount() > 0){
 for (prop in testStep.getPropertyList()){
  log.info(prop.getName() +" "+ prop.getValue())
 }
}
      • roja1's avatar
        roja1
        Contributor
        6 years ago

        Hi,

         

        Thank you. It helped me to get the properties.