Forum Discussion

anagpal's avatar
anagpal
Occasional Contributor
6 years ago

SoapUI (Pro) > DataDriven > Message Content Assertion - How to handle decimal values

I am using ReadyAPI(SoapUI Pro) for testing of a RestAPI. For TestData I'm using DataSource (DataDriven), where i am giving the Inputs (API Input) from excel. And to test the API response i am comp...
anagpal's avatar
anagpal
Occasional Contributor

Hi avidCode,

 

Thnaks for your reply. I am little bit confuser here, i tried but assetion is always pass even for wrong values as well. 

I need youe help to create the assetion: (we are using JSON as API request/response)

 

Scenarios: DataSource Testing

In Excel I have inputs as well ouputs, for one of scenario My excel (DataSource) output is :

( '${DataSource#Output_LoanTerm}' )   --> Value is 45

 

Now when i used Data Source for executing my test case API returns:
$['LoanTerm']  --> Value is 45.0

 

I want to match ( ${DataSource#Output_LoanTerm})  =  $[LoanTerm] 
(45 = 45.0)

 

Assertion failed, (due to .0). I tried the Assertion using Groovy script but no luck (may be i have no experience of Groovy Script). Can you please send me an example with above case.

 

Or can we use the JSONPath Asseretion for contect match as well, If yes please help, sorry as i have no knowledge of JSON :)

 

avidCoder's avatar
avidCoder
Super Contributor
6 years ago

( '${DataSource#Output_LoanTerm}' )   --> Value is 45

After this convert it into double like the below code:-

def data = 45
def newData = new Double(data).round(2)
printf("${newData}")

 So, this will give you 45.0 as output and then

$['LoanTerm']  --> Value is 45.0

Match ( ${DataSource#Output_LoanTerm})  =  $[LoanTerm] 

 

Try this again and let me know.

 

If you are ok with answer. please don't forget to accpet as solution and kudos.

  • anagpal's avatar
    anagpal
    Occasional Contributor
    6 years ago

    Hi,

     

    I tired but no luck :(

    So where to add this code: 

    def data = 45
def newData = new Double(data).round(2)
    printf("${newData}")

    In excel or Assetion window (JSON Path Expression) 

  • anagpal's avatar
    anagpal
    Occasional Contributor
    6 years ago

    Hi,

     

    I tired but no luck :(

    So where to add this code: 

    def data = 45
def newData = new Double(data).round(2)
    printf("${newData}")

    In excel or Assetion JSON Path Expression

    • avidCoder's avatar
      avidCoder
      Super Contributor
      6 years ago

      Hey, you need to add this code where erver you are trying to do assertion.

       

      And also if you are using Ready API tool use, log.info to print anything.

      • anagpal's avatar
        anagpal
        Occasional Contributor
        6 years ago

         

        I tried in JSONPath Asertion: Here in example, API Response - $['availableIncome'] = 1420.0

        And in Expected result, I am checking the value from my excel (test Data expected output = 1420)

        In expected result i added: 

        def data = ${TestData-StandardLoan#Output_AvailableIncome} def newData = new Double(data).round(2)
        printf("${newData}")

        But it doen't work