[Resolved] JSonPath vs XPath

This is an update that our 5.1 Release of SoapUI Pro has introduced JSONPath assertions when the response is JSON.
This is a Pro only release.

Regards,

Giscard
SmartBear Support

You would use "ResponseAsXml" instead of the previous "Response".

Thanks for the response SiKing. Unfortunately, it didn't entirely solve my problem.

In the Property Transfer step when I had this set to Response with an XML Response I had //Document/DocumentId to grab the data from the node.

As you suggested in the Property Transfer step I changed the Source Property to "ResponseAsXml" with a JSON response.

I didn't expect the //Document/DocumentId to work and it didn't with the JSON response.

I am fairly knew to XPath and am not sure what the correct XPath reference should be to access the same node I was using with the XML response.

I've figured out the syntax.

//*:Documents/*:Document[1]/*:DocumentId

Thanks for your help.

kralston wrote:
I didn't expect the //Document/DocumentId to work and it didn't with the JSON response.

Based on absolutely nothing, my guess is something like this will work:

//*:Document//*:DocumentId

kralston wrote:
I am fairly knew to XPath and am not sure what the correct XPath reference should be to access the same node I was using with the XML response.

Try this: http://www.zvon.org/xxl/XPathTutorial/G ... mples.html

It sounds like you got an answer. For another recommendation in grabbing JSON values, try JsonSlurper library in Groovy. The following article has a good example: http://www.robert-nemet.com/2012/08/jso ... oapui.html

Thanks,
Michael Giller
SmartBear Software

Thanks Michael

I found quite a bit of info on JSONSlurper and have been using it in a number of places in my tests.

You can use DefiantJS - which enables XPath queries on JSON structures.
http://defiantjs.com
https://github.com/hbi99/defiant.js

Try the XPath evaluator to become an expert on XPath;
http://defiantjs.com/#xpath_evaluator

var data = {
    "movie": [{"id": 1, "title": "The Usual Suspects"},
              {"id": 2, "title": "Pulp Fiction"},
              {"id": 3, "title": "Independence Day"}]
     },
     res = JSON.search(data, '//*[id=2]');

console.log( res[0].title );
// Pulp fiction

As you can see, DefiantJS extends the global object JSON with the search method. Check out the documentation for more details.