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
Access Variable Library in Semantic Models
Enable the Variable Library as a centralized location for storing all environment‑specific variables, allowing us to adjust them for promotion scenarios (e.g., from dev to prod) without relying on de...FreddyH3 hours agoAdvocate IINew910Views31likes2CommentsEnhance Fabric Pipeline Monitoring with Parent-Child Pipeline Lineage and Parameter Visibility
Currently, Microsoft Fabric Pipeline monitoring lacks several capabilities that are available in Azure Data Factory, making troubleshooting and operational support challenging in enterprise environme...dwramreddy3 hours agoRegular VisitorNew2Views0likes0CommentsDynamic ADLS-Gen2 path input for Spark Jobs Main definition file
I would like the ability to add a dynamic input box on a spark job definition's "Main Definition File" "ADLS-Gen2 path". this would be useful to set base and variable paths across all spark jobs...mfink_db8 hours agoNew MemberNew238Views2likes2CommentsReintroduce Tenant/Capacity Switch to Control "Users can create Plan items" Post-GA
During the Preview phase of Fabric Plan items, administrators had access to a dedicated tenant/capacity setting: "Users can create Plan items". With General Availability (GA), this granular administr...Sri-Surendra_Ku10 hours agoNew MemberNew106Views14likes1Comment