Forum Discussion
nmrao sir, here is the sample data:--
response from jdbc :-----<Results><ResultSet fetchSize="0"><Row rowNumber="1"><CAT.ID>2</CAT.ID><CAT.ROLL_NO>100</CAT.ROLL_NO><CAT.NAME>Enid</CAT.NAME><CAT.PASSWORD>12345</CAT.PASSWORD><CAT.STATUS>1</CAT.STATUS></Row><Row rowNumber="2"><CAT.ID>9</CAT.ID><CAT.ROLL_NO>101</CAT.ROLL_NO><CAT.NAME>Alisha</CAT.NAME><CAT.PASSWORD>67891</CAT.PASSWORD><CAT.STATUS>1</CAT.STATUS></Row><Row rowNumber="3"><CAT.ID>15</CAT.ID><CAT.ROLL_NO>102</CAT.ROLL_NO><CAT.NAME>Dave</CAT.NAME><CAT.PASSWORD>45637</CAT.PASSWORD><CAT.STATUS>1</CAT.STATUS></Row></ResultSet></Results>
and json response of a web service is:--
{
"customer": [
{
"last_name": "jayswal",
"roll_num": "100",
"password": "85658",
"first_name": "Enid",
"email": "dk@gmail.com"
},
{
"last_name": "jayswal",
"photo": "105",
"roll_num": "85658",
"first_name": "shalin",
"email": "dk@gmail.com"
}
]
}
Now i want to compare roll no. =100 is equal to any roll no. from the json response
Also, i am very new in automation. So, please enlighten me in detail regarding this query i posted. I shall be grateful to you.
Thanks.
There is script created, can you try modifying it to your need. If you still have issue, post what you tried .
https://github.com/nmrao/soapUIGroovyScripts/blob/master/groovy/compare/JdbcAndJsonCompare.groovy
Related Content
- 3 years ago
- 7 years ago
Recent Discussions
- 15 years ago