How to Assert Repeating Json Attributes Have The Same Value?

Question

Hey!
&nbsp;
I am testing a REST service and some of my&nbsp;GET request's Query Parameters actually appear as an attribute in my .json response (obviously) filtering the request.&nbsp;&nbsp;
&nbsp;
e.g. if request is GET --&gt; whatever/rich?VersionNumber=1
&nbsp;
my resultset returns records where VersionNumber=1 and furthermore includes a VersionNumber field in the response.
&nbsp;
e.g.
&nbsp;
$['data'][0]['VersionNumber']=1
$['data'][1]['VersionNumber']=1
$['data'][2]['VersionNumber']=1
&nbsp;
I'm trying to put a nifty assertion together (I don't know if it's possible) so that I can assert that each of the VersionNumber attributes in the .json response is identical to the VersionNumber QueryParameter in my REST request.&nbsp;
&nbsp;
If I select the 'Select Content' button, I can navigate through to the properties associated with my testcase and select the VersionNumber property which generates the '${REST Request#VersionNumber}' parm in the expected results.
&nbsp;
This would be perfect if there was only 1 record returned in the resultset - but there can be ANY number - I need to be able to assert that EVERY 'VersionNumber' attribute in the resultset has the same value as the QueryParameter VersionNumber value (or at the least - all VersionNumber attributes have the SAME value - even if I can't map it directly back to the VersionNumber QueryParameter property value.)
&nbsp;
Would anyone know how to do this?
&nbsp;
I found this --&gt;&nbsp;which looks like someone else asked the same question BUT it was for XML - but this works for xml - I don't think it works for json:(
&nbsp;
I hope I've been clear!
&nbsp;
Many thanks!
&nbsp;
richie

nmrao · Accepted Answer

richie ,
&nbsp;
Thank you.
&nbsp;
Below is the script assertion which will fetch all the VersionNumber's from data array and check each value is 1
&nbsp;
assert context.response, 'Response is empty or null'
def json = new groovy.json.JsonSlurper().parseText(context.response)
assert json.data.VersionNumber.every{1 == it}

nmrao · Answer

richie,It would always be helpful for quick &amp; better understanding if explanation associated with a sample data (not really be the actual data) resembling the same structure that you need to work with. Because, people do not have to imagine or easy to help by copying your data and apply logic reducing their time.

richie · Answer

you're right - I know better than that&nbsp; - so apologies!
&nbsp;
Please find attached an example response - I removed most of the records - but I left 3 in there so you can see the repeating pattern.
&nbsp;
thanks man,
&nbsp;
richie

richie · Answer

Hey&nbsp;rao
&nbsp;
that's perfect fella - exactly what I need! :)
&nbsp;
I was trying to expand the snippet a little - as I have a property created in the request via the VersionNumber QueryParameter that is available via&nbsp;('${REST Request#VersionNumber}') - I was trying to edit the snippet&nbsp; - changing the script from&nbsp;
&nbsp;
assert context.response, 'Response is empty or null'
def json = new groovy.json.JsonSlurper().parseText(context.response)
assert json.data.VersionNumber.every{1 == it}
to&nbsp;
assert context.response, 'Response is empty or null'
def json = new groovy.json.JsonSlurper().parseText(context.response)
assert json.data.VersionNumber.every{context.expand ('${REST Request#VersionNumber}') == it}
I tried variations of this and I've done a bit of reading about the 'it' and 'every' groovy functions -&nbsp; but I can't quite tweak the script assertion so it's successful - the assertion always fails
&nbsp;
I was wondering about the datatype - and I think I've noticed beforehand that the context.expand treats properties as string rather than numerics, so I tried adding the .toInteger() method at the end of the parameterization as follows:
assert context.response, 'Response is empty or null'
def json = new groovy.json.JsonSlurper().parseText(context.response)
//assert json.data.VersionNumber.every{1== it}
assert json.data.VersionNumber.every{context.expand('${REST Request#VersionNumber}').toInteger() == it}
&nbsp;
and it worked! :)
&nbsp;
Hahahaha! very excited I managed to do this without someone giving me the answer! :):):):):):)
&nbsp;
Thanks to all, and special thanks to&nbsp;rao - yet again for saving my life
&nbsp;
nice one,
&nbsp;
richie
&nbsp;
&nbsp;

nmrao · Answer

Glad to know that. Goovy is easier. Isn't it?

richie · Answer

rao
&nbsp;
hahahaha!&nbsp; well I don't know about 'easier' - but it certainly allows for tailoring your test cases to do exactly what you need - which the OTB functionality doesn't (as good as the OTB functionality actually is) and it's also a lot more fun when you solve a problem!
&nbsp;
I have another question - based on your previous script to build the request (using groovy) and adding this script assertion into that script.&nbsp; I was going to create a new subject post - but honestly? this is so specific - I couldn't think of a decent title - and I'm unsure if anyone else would have this specific issue - so I just continued on this post.&nbsp; If you feel this needs a separate post, I will do so.
&nbsp;
So - in summary I wanted to add in the script assertion you've given me, to the groovy script you've already provided to build the GET request.&nbsp; I've managed to update the script so it works, if I don't parameterize the asserted value in the script assertion - if I do parameterize it, the assertion now fails - see below for the updated script - the bit I'm concerned with is in red text
//script courtesy of Rao of https://community.smartbear.com//import decs
import groovy.json.*
import wslite.rest.*

def serviceHost = context.expand ('${#Project#TestEndpoint}') //'https://whatevs.azurewebsites.net'
//Below to handle template parameter, additional $ required before
def getNamespaceDatasetPath = '''/api/1/${namespace}/${dataset}'''
//define all template param values as shown below
def binding = [namespace : context.expand( '${#TestCase#namespace}') ,  dataset : context.expand('${#TestCase#dataset}')]
//def binding = [namespace : 'certification-nomenclature', dataset : 'certification-nomenclature']

def template = new groovy.text.SimpleTemplateEngine().createTemplate(getNamespaceDatasetPath)

def queryParams = [:]
//Get the properties of Property Test step
context.testCase.testSteps["Properties"].properties.each {
	queryParams[it.key] = it.value.value
}
def client = new RESTClient(serviceHost)
def response = client.get(path: template.make(binding) as String,
					 accept: ContentType.JSON,
					 query : queryParams
					 )
assert response.statusCode == 200
log.info groovy.json.JsonOutput.prettyPrint(response.text)

def object = new JsonSlurper().parseText(response.text)
assert object.header.success == true

//the next four lines are the original script assertion
assert response.text, 'Request parameter is correct'
//def json = new groovy.json.JsonSlurper().parseText(response.text)  //this line isn't needed as I already pass the response to the object variable above
assert object.data.CertificateType_Code.every{'C'== it}//I want to replace the line above with the next line so I parameterize the value being asserted on
//assert json.data.CertificateType_Code.every{context.expand('${REST Request#CertificateType_Code}') == it}

def count = 'count'
def step3 = context.testCase.testSteps['Properties2']
//step3.propertyNames?.each { step3.removeProperty(it) }
def prop3 = step3.hasProperty(count) ? step3.getProperty(count) : step3.addProperty (count)
prop3.value = object.meta.count
I think I understand why the script is failing - the script is NOT recognising the teststep name of 'REST Request' &lt;-- this is the name of the groovy step that contains the above groovy - but I don't know why it's not recognising the test step name.
&nbsp;
&nbsp;
The script assertion works if I don't parameterize the assertion value - so I know this is the problem - can anyone advise?
&nbsp;
I should highlight that I did a quick check to see what ReadyAPI! recognised the test step name as using the 'Get Data' function to point to the groovy step - but it created a line of code that indicated ReadyAPI! sees the step as 'REST Request', so I don't know why this parameterized assertion isnt working.
&nbsp;
I've attached a screenshot so you can see the test case just to add a little clarity!
&nbsp;
thanks to all!
&nbsp;
richie

Forum Discussion

How to Assert Repeating Json Attributes Have The Same Value?

6 Replies

Related Content

Assert Repeating JSON Attribute Sorted Order

error: Attribute paths is repeated

An Assertion To Verify Repeating Attribute Contains All Upper Case Chars?

Script Assertion Query - Verify a repeating .json attribute has specific value domain?

Defining conditional attributes in OpenAPI

Recent Discussions

JDBC results are stored in the ReadyAPI project

Azure Git Integration?

How to run specific test case in particular environment?

How to remove (not clear) test case properties from SaveScript

Parameterising JDBC Connection Settings..Can you do it?