How to Compare an array from one Json Response to an array from another Json response.

[dipsthorat]

Hi All,

I have 2 different json array and need to validate every n each attribute against each other .Earlier I used Message content assertion but I need to do for all array item manually. for example there is array for "Route"

is there any other way to compare array of response ?

[Fisher021]

Extract the data from the response body (JSON object array) in the form of JSON string Glasshouse view of code quality with every check-in In automating the requests, we need to pass the data in many requests in different forms.

expressHR

[nmrao]

You need to use groovy to achieve the same.

[dipsthorat]

Can you please help on this to me @nmrao

[nmrao · Accepted solution]

Here is a sample to compare two lists (books in this case). But you need to adopt the changes as per your data.

def expectedJson = '''{
    "book": [
        {
            "title": "Beginning JSON",
            "price": 49.99
        },

        {
            "title": "JSON at Work",
            "price": 29.99
        }
    ]
}'''

def actualJson = '''{
    "book": [
        {
            "title": "JSON at Work",
            "price": 29.99
        },
        {
            "title": "Beginning JSON",
            "price": 49.99
        }
    ]
}'''

//Note that the order of books are different in the above 

def getJson = { str -> new groovy.json.JsonSlurper().parseText(str)}
def expectedBooks = getJson(expectedJson).book
def actualBooks = getJson(actualJson).book

//Check if both lists are sorted and compared
assert actualBooks.sort() == expectedBooks.sort()

[myestub1]

I Have really enjoyed this blog, you’re a great author.

myestub

[twitchbitstous]

Such an amazing story please share more stuff I really like these posts.

twitchbitstousd

[FaxCoverSheet1]

I have seen the first-time Article it is so wonderful thanks for sharing this article.

FaxCoverSheet

[fmcdealer]

I have seen this article this is very nice thanks for sharing it with us.

fmcdealer

[myaccessflorida]

Thank you so much for this Article this is very useful.

myaccessflorida