Forum Discussion

SanK's avatar
SanK
Occasional Contributor
5 years ago
Solved

Compare 2 JSON responses for duplicate property value

Hi, I have two JSON responses that will have dynamic nodes on each request, but same structure and properties. I need to identify if a given property has no duplicate values found in both the JSON r...
Assertions
data-driven testing
REST
Scripting
  • nmrao's avatar
    nmrao
    5 years ago

    SanK 

    - add a script assertion to both the request test steps with the below code

    - below script would check the response and makes the test fail if there are duplicate values for "ReferenceNumber" property

     

    Hoping this is what you need, reply back otherwise.

     

    def duplicateRefs = new groovy.json.JsonSlurper().parseText(context.response).ReferenceNumber.countBy{it}.findResults { it.value > 1 ? it.key : null }
log.info "${duplicateRefs.size() > 0 ? 'Duplicate reference numbers found :' + duplicateRefs : 'No duplicate reference numbers'}"

assert [] == duplicateRefs, "Duplicate references found, ${duplicateRefs}"
  • nmrao's avatar
    nmrao
    5 years ago

    SanK 

    Here is the Groovy Script

    - Add a groovy script after the second test request step

    - Provide correct values step1, and step2 

     

     

     

    //Update the Request step names below
def step1 = 'Name of the Request step1'
def step2 = 'Name of the Request step2'

//Closure to get the ReferenceNumber from a json of the Given test step
def refNumbers = { step ->  new groovy.json.JsonSlurper().parseText(context.testCase.testSteps[step].getPropertyValue('response')).ReferenceNumber }
def list1 =  refNumbers(step1)
def list2 =  refNumbers(step2)
log.info "Reference Numbers for ${step1} are => ${list1}"
log.info "Reference Numbers for ${step2} are => ${list2}"
assert list1.every { !list2.contains(it) }, 'Does not match the expected result'

     

     

    -  

nmrao's avatar
nmrao
Community Hero
5 years ago
It would easy to compare the person once we get the exact person from the array.

Looks you posted the pieces from the response. Is it possible to show the full json structure instead of pieces.
Because the solution would depend on it.
It need not be exact response but hierarchy is needed.
SanK's avatar
SanK
Occasional Contributor
5 years ago

Thanks nmrao I have now attached two JSON files that would provide some idea for the structure. In these two JSON files I'm looking for duplicate values for property - "ReferenceNumber". Ideally these JSON responses Im thinking will not be saved as files to be compared, but any way we can use groovy to read the responses and find the duplicate values for property "ReferenceNumber"

  • nmrao's avatar
    nmrao
    Community Hero
    5 years ago

    SanK 

    - add a script assertion to both the request test steps with the below code

    - below script would check the response and makes the test fail if there are duplicate values for "ReferenceNumber" property

     

    Hoping this is what you need, reply back otherwise.

     

    def duplicateRefs = new groovy.json.JsonSlurper().parseText(context.response).ReferenceNumber.countBy{it}.findResults { it.value > 1 ? it.key : null }
log.info "${duplicateRefs.size() > 0 ? 'Duplicate reference numbers found :' + duplicateRefs : 'No duplicate reference numbers'}"

assert [] == duplicateRefs, "Duplicate references found, ${duplicateRefs}"
    • SanK's avatar
      SanK
      Occasional Contributor
      5 years ago

      Thanks a lot for this nmrao. The script will obviously help me in identifying duplicate reference numbers in individual JSON response. However, I'm looking for any "ReferenceNumber" value in JSON1 is not matching in JSON2 and vise versa. In other words none of the reference numbers in JSON1 should match with any of the reference numbers in JSON2. Sorry for the confusion.

      • nmrao's avatar
        nmrao
        Community Hero
        5 years ago
        Do you mean, both shouldn't have anything in common?