DQL parsing on a xmlns log

[Alexis1]

Hello community,

I have difficulties to parse xmlns structure of log with DQL, the purpose of parsing this is obtain the values of xml attributes, is there any of you that have experience with this. I will copy an example structure, since it contains sensitive information for the client.

16:26:04,552 INFO [**.***.*****.******.*****.******.***] (http-200.10.x.1xx:xx-x) method - BODY received: <v20:******************* xmlns:v20="http://example.cl/exampleroute">
<firstAttribute>Example</firstAttribute>
<secondAttribute>Example1</secondAttribute>
<thirdAttribute>Example2</thirdAttribute>

Thanks in advance.

[PacoPorro · Accepted solution]

Did you try something like this?:

PARSE(content, "DATA '<firstAttribute>' DATA:firstAttribute '</firstAttribute>' DATA '<secondAttribute>' DATA:secondAttribute'</secondAttribute>' DATA '<thirdAttribute>' DATA:thirdAttribute'</thirdAttribute>' ")

[Alexis1]

Hi Paco,

i didn't try this, i was trying the way that Dynatrace show us at DQL Use cases documentation and nothing works, thank you for your help!