Querying JSON the XPath 3.1 way
Posted: Sat Apr 20, 2019 10:25 am
In https://www.oxygenxml.com/doc/versions/ ... rming.html, it is explained how to use XSLT or XQuery to transform JSON input and https://www.oxygenxml.com/doc/versions/ ... query.html explains how to use "XPath" to select data from a JSON document.
To my suprise, these topics seem to use completely different approaches as the "XPath" expressions used to select data from a JSON file seem to rely on an oXygen internal JSON to XML conversion and query that XML while the samples on XSLT and XQuery use the XPath 3.1 way of representing JSON as maps and arrays.
I would like to see a way to use the XPath toolbar with expression completion against a JSON document supporting the XPath 3.1 syntax (e.g.
It would also be nice to have the "copy XPath" menu to allow generating such XPath 3.1 expressions.
To my suprise, these topics seem to use completely different approaches as the "XPath" expressions used to select data from a JSON file seem to rely on an oXygen internal JSON to XML conversion and query that XML while the samples on XSLT and XQuery use the XPath 3.1 way of representing JSON as maps and arrays.
I would like to see a way to use the XPath toolbar with expression completion against a JSON document supporting the XPath 3.1 syntax (e.g.
Code: Select all
?personnel?person?*[?link?manager = "Big.Boss"]?name?given