Blog Post

Azure Data Explorer Blog
1 MIN READ

How to query XMLs with namespaces as dynamic columns in Azure Data Explorer (Kusto)

Tzvia's avatar
Tzvia
Icon for Microsoft rankMicrosoft
Apr 15, 2019

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"]

 

Updated Apr 15, 2019
Version 2.0
No CommentsBe the first to comment