How to query XMLs with namespaces as dynamic columns in Azure Data Explorer (Kusto)
Published Apr 15 2019 04:54 AM 6,101 Views

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=""></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: