How to query XMLs with namespaces as dynamic columns in Azure Data Explorer (Kusto)
Published Apr 15 2019 11:54 AM 7,114 Views
Microsoft

XML parse into dynamic column can be done with parse_xml(x). 

Here is a workaround to enable translation of XMLs with namespaces.

 

datatable (dumpInput:string)
    ['<SOAP-ENV:Envelope xmlns:e="http://www.test.com"></SOAP-ENV:Envelope>']   
| extend x = replace("<(.+?):", @"<\1", dumpInput)
| project s=parse_xml(x)
| extend s["SOAP-ENVEnvelope"]["@xmlns:e"]

 

Version history
Last update:
‎Apr 15 2019 02:03 PM
Updated by: