I want to use "xpath" to extract data from xml.
or to define element I want in web query.
Hear hear, navigating the trees can be very difficult; an option to use the xpath would be very helpful.
Does anyone else need to get data from XML files in a more organized/flexible way?
I have a set of XML files that I'd like to use, but the hierarchy is a bit too complex to deal with easily.
It would be awesome if there were an xPath function! Something like ListOfNodes = XML.xPath(<contextNode>, <xPathStmt>), where each node would be a record from the XML.Document table, but with [Parent = <Parent>] metadata. Could work with web-sourced xml too.
I almost tried implementing a basic interpreter myself in M, but it's hard without Regular Expression (another feature we badly need) functions to parse anything more complex than "/bookstore/book".
Anyone else need this, or manage to build themselves a workaround?