I want to use "xpath" to extract data from xml. or to define element I want in web query.
5 Comments
- alan_thomasNew MemberDoes 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(
, ), where each node would be a record from the XML.Document table, but with [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? - kpjoubertNew MemberHear hear, navigating the trees can be very difficult; an option to use the xpath would be very helpful.
- dhananjay1405New MemberWeb.Content fails in some cases where many nested tables are found containing ultimate information to extract. XPath will be handy to query the exact path of Table
- pdsoutherland2New MemberWould be very useful for accessing data in tables on web sites.
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Allow External OneLake Data Shares to Be Accepted into Multiple Fabric Item Types
Fabric External Data Sharing provides an excellent zero-copy mechanism for sharing OneLake data across tenants. However, the receiving tenant currently has to accept the share into a Lakehouse. I w...Mourak18 hours agoNew MemberNew5Views0likes0CommentsAllow OneLake Shortcut Authentication Mode to Be Changed In Place
OneLake shortcuts support passthrough and delegated authentication, but changing the authentication model currently requires deleting and recreating the shortcut. I would like shortcut authenticatio...Mourak18 hours agoNew MemberNew7Views0likes0CommentsTenant-Wide OneLake Shortcut Lineage and Impact Analysis
This is grounded in a documented limitation: shortcut lineage is currently workspace-scoped, and Microsoft specifically says lineage for shortcuts to warehouses and semantic models isn't currently av...Mourak18 hours agoNew MemberNew15Views0likes1CommentAdd an End-to-End Production Reference Architecture for Microsoft Fabric Real-Time Intelligence
I would like to see a complete end-to-end Microsoft Fabric Real-Time Intelligence reference architecture that demonstrates how the individual RTI capabilities work together in a production-oriented s...Mourak18 hours agoNew MemberNew5Views0likes0CommentsImprove CI/CD consistency for Microsoft Fabric Real-Time Intelligence Eventstreams
Microsoft Fabric Real-Time Intelligence has made strong progress with Git integration and deployment pipelines, but lifecycle management can still be inconsistent across Eventstream sources, destinat...Mourak18 hours agoNew MemberNew3Views0likes0Comments