topic DQL parsing on a xmlns log in DQL

DQL parsing on a xmlns log

Alexis1 — Tue, 05 Mar 2024 09:39:43 GMT

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.

Re: DQL parsing on a xmlns log

PacoPorro — Tue, 05 Mar 2024 07:22:02 GMT

Did you try something like this?:

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

Re: DQL parsing on a xmlns log

Alexis1 — Tue, 05 Mar 2024 12:21:34 GMT

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!