Forum Discussion

sparrowenclave's avatar
sparrowenclave
Occasional Contributor
5 years ago

How to get Integer value from excel and store in Soap UI properties step

  I have one data in excel which holds numeric value and when I am sending the same value from Excel to Soap UI properties, it's value getting converted into string like below: In Excel: Value of ...
  • HimanshuTayal's avatar
    HimanshuTayal
    5 years ago

    Hey!! Thanks for mentioning richie , yes you are absolutely correct.

     

    This is happening because Properties Step stores values in (key : value) pairs which are (String : String) if you want to use it as Integer than you need to parse it into integer.

     

richie's avatar
richie
Community Hero
Hey sparrowenclave,

Are you saying youve already extracted the value and stored as a property already? As youve noticed poperties are stored as strings by default. Im typing this out on my phone (not sitting in front of laptop and so going on memory), but if you have the property stored at testcase level you can try the following:

// grab property from testcase level
def propStringValue = testRunner.testCase.getPropertyValue("propertyName")
//cast the string to integer type
def propStringValue = propStringValue.toInteger()

The above code will cast the string to integer type if property stored at testcase level. Youd need to edit if its stored elsewhere.

I need to highlight that HimanshuTayal gets the credit for this....i just ripped this from one of his answers!

Nice one,

Rich
HimanshuTayal's avatar
HimanshuTayal
Community Hero
5 years ago

Hey!! Thanks for mentioning richie , yes you are absolutely correct.

 

This is happening because Properties Step stores values in (key : value) pairs which are (String : String) if you want to use it as Integer than you need to parse it into integer.