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

lets please stick to the original question... folks can you please help me on this its been 3 days and am hunting for the solution. This morning I have 2 issues my iterator of the reponse isnt printing results 

1.my iterator is not printing result which it did earlier

 

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

}

Issue 2 : how do i add the results of database return and the above to an arrays and compare the results. Hit a blank wall.please help

  • ilovechiku's avatar
    ilovechiku
    Contributor
    9 years ago

    that was a helpful post thanks Rao. 

    this is what i have so far 

     

     

    /******* Create a Array and add all employeeIds from reponse*******/

    def responseList = []

    jsonRes.Items.EmployeeId.each {

        responseList.add(it.value) //'it' is the name of the default iterator created by the .each()

      //log.info "all the employee ids in reponse in array"+responseList

    }

     

    /******* Create a Array and add all employeeIds from Database*******/

    def empIdFromDB = []

    returntripDB.each {

        empIdFromDB.add(it.value)

      //   log.info "all the employee ids in reponse in array"+empIdFromDB

    }

     

    //sorting the Data before checking for equality

    def a = responseList.sort()

    log.info "all the employee ids in reponse in array"+a

    def b = empIdFromDB.sort()

    log.info "all the employee ids in DB in array"+b

     

    BUT the result am getting is not what i want: below is the result

     

     

    all the employee ids in reponse in array[29, 2, 6, 1, 4, 3, 5]
    all the employee ids in DB in array[ , ,, , ], 6, ,, ,, ,, 4, 9, 5, , , 2, [, , , ,, ,, 2, 3, 1]

     

    Why is it not sorting the data.Also why is the DB results all screwed up?.

     

     

  • nmrao's avatar
    nmrao
    Champion Level 3
    9 years ago
    It appears that db is returning results as list some times. So it is adding list when you add, inside of a list. Please check it.
  • ilovechiku's avatar
    ilovechiku
    Contributor
    9 years ago

    Iam sorry but iam seeking answer since am not a groovy expert. All i know is i am capturing results in a array.

     

    please help.

  • nmrao's avatar
    nmrao
    Champion Level 3
    9 years ago
    With given details, it is difficult to provide exact solution that works with your data.
    You need to check(can use instanceof List) if empIdFromDB is List/Array, then again do loop then add value.
  • ilovechiku's avatar
    ilovechiku
    Contributor
    9 years ago

    what information do you need ?.