In our project we use REST - JSON service. Currently in SoapUI, the JSON Response is auto converted to XML format. This is helping in easily adding assertions or creating filters by xpath. In CA LISA, we did not see any option to convert JSON format response in XML. Due to this we could not add assertions or filters the way we do it on SOAP-XML request. How can we do this in CA LISA? Or is there a better way/option in LISA to directly add assertions on JSON file formats?
This functionality in 8.0 seems to be exactly what we're looking for...thanks for responding!
- 1 person found this helpful
Hi , Had a similar requirment some time back and tracked a solution written by Jeff ( JSON TO XML FILTER) , See If it can be helpful to you.
I have attached the JARS , But be careful which version you are using this with , I used with 7.5.2 and worked fine.
For 7.5.1 , had to convert a response property in to a string first.
drop me an email will send you the util code --vinay.gupta@ca.com
Merry Christmas
Email sent...will definitely try the utility code out. Thanks!
n u please share this jar as we have a requirement? Have sent an email. Thank you.
Hi Vinay,
We have a similar requirement in our project where we need to filter a JSON response returned by the REST service. We are using LISA version 7.5.1. Can you please provide the more details on the utility you have mentioned and also how can we get it.
Thanks,
Saberesh
Hi All,
i Lisa 7 we can create filters on JSON Response by using Lisa option to create filters based on surrounding values , i have tried and it worked.
You just need to mark the value which u want to save as filter in property block which is enclosed by must or any blocks
Let me know if you require more info on this
Thanks,
Venakatesh
I want to compare a Json response message from 1 service to a soap response message from another service.
Both services are suppose to return same response in different formats.
Is there any way to compare there two?
is it possible to convert json to soap or soap to json message in lisa?
Thanks,
Pankaj
Hi,
We already have JSON parser in place. Use that JSON step to get JSON keys and properties and compare against other format messages. Not a good approach like inbuilt XML comparison but try that for time being.
Thanks
In 8.0 we added the ability to do filters and assertions on JSON data based on JSONPath, here is the blog discussing that The 12 days of 8.0 - Day 10
There are field created filters available to convert json to xml if you need the conversion for some other reasons. Send let me know if you need that.
Regards,
Arif