GetData based on another value
I have a test I am trying to make more robust since DB ID's change often.....
I call one API to retrieve the informaiton I need. I need to now use a value that i returned based on another value...
Forum Discussion
endorium ,
Use below script assertion for the REST Request test step which will extract the id value and saves it at test case level custom property, say ID, which can be used used in further test steps of the same test case.
/**
* Script Assertion for REST Request test step
**/
//Change the value for below statement as needed
def expectedMatchingProperty = 'Action Code'
assert context.response, 'Response is empty or null
def json = new groovy.json.JsonSlurper().parseText(context.response)
context.testCase.setPropertyValue('ID', json.data.find {it.propertyName == expectedMatchingProperty}?.id?.toString())
Use ${#TestCase#ID} where it is required later in the test steps.
Hi
Thanks for the code but it does not seem to work. See the screenshot
- Sorry about it, there was typo.
Change below statement from:
context.testCase.setPropertyValue(json.data.find {it.propertyName == expectedMatchingProperty}?.id?.toString())
To
context.testCase.setPropertyValue('ID', json.data.find {it.propertyName == expectedMatchingProperty}?.id?.toString()) - There is another change it seems
Change from (there is space in your response')
def expectedMatchingProperty = 'ActionCode'
to
def expectedMatchingProperty = 'Action Code'Thank you. That worked.
Now.......I have another 20 I need to do for that API. Whats the best way to add them all?
Do i just repat the code you have provided (but updating the expected match property)? How can I name them differently so I can then call them individually like you put above ${#TestCase#ID}
You have been very helpful :) Learnt somethign very useful today!
- Glad it helped.
When there is problem to solve, it would always better to provide complete information at the first so that it would save time to arrive to the best possible solution instead going by iterations which may take both your and others time.
A request has to be created based on the response of the previous response? Is it the actual problem you are trying to achieve?
Would you please provide the sample response and expected following request (both in text format, not images) to resemble the actual solution you are trying to arrive?
Was trying to be clever and get the the id by doing this.
${LISProperties#Response#$['data'][?(@.translationkey=ActionCode)].data.id}
LISProperties is the request that pulls the data back. This does not seem to work but I think the above is slightly wrong? The Json structure is in the screenshot. Trying to avoid the numeric value under data as theis wont always be the same. Can you skip a level in the query like I have done above?
