Forum Discussion

ilovechiku's avatar
ilovechiku
Contributor
9 years ago

Compare response to table values

I have a response(i have multiple such entries copied only one.) like below and I have a table that I need to compare it against. { "Items": [ { "EmployeeId": "1", "CompanyId": "1", "FirstName"...
ilovechiku's avatar
ilovechiku
Contributor

 

 

 

was able to get the reponse to print like this 

 

jsonRes.Items.EmployeeId.each
{
//groovy iterator
def valueOfEmployee=it.value

log.info myResponsevalues
}

 

the result was 

1
113
129
130
131
134
136

 

Also I was able to get the DB results like below //log.info "DB values"+returntripDB

DB values[1, 113, 129, 130, 131]

 

How can I compare these two values?

please help

nmrao's avatar
nmrao
Champion Level 3
9 years ago
Instead of printing the values from json response, add them to an arraylist.
From jdbc also you would get arraylist.
And use assert to compare both the lists. Make sure both lists are sorted before the assert.
  • ilovechiku's avatar
    ilovechiku
    Contributor
    9 years ago

    I dont have a JDBC step.. how can i add this query result to an Array ? and compare the two

    can you please help.

    • nmrao's avatar
      nmrao
      Champion Level 3
      9 years ago
      What I meant was that you already have result from getEmployeeFromDB to get the data.
      Below assert will do the compare actual vs expected.
      assert expected == actual, "Not matching"
      • bs01's avatar
        bs01
        Occasional Contributor
        9 years ago

        The limitation in this apporach is, if i write method to compare two values (without assertion) and want to print to results (html results), it is not possible. That is the drawback with SoapUI tool.