https://community.dynatrace.com/t5/DQL/Parse-JSON-Data-Using-DQL-for-Advanced-Querying/m-p/290423#M2830 <P>something like this could work:</P><LI-CODE lang="markup">data record(content="{\"logger\":\"**************\",\"message\":\"Detalle error respuesta API, nit real ********02464,fecha inicial 2025-11-21 , fecha final 2025-11-23 página 0 . Datos cuenta: [] -&gt; {\\\"meta\\\":{\\\"_messageId\\\":\\\"**\\\",\\\"_requestDateTime\\\":\\\"2025-11-25T07:09:51.993-05:00\\\",\\\"_applicationId\\\":\\\"6*c2\\\"},\\\"status\\\":404,\\\"title\\\":\\\"Not Found\\\",\\\"errors\\\":[{\\\"code\\\":\\\"BPQR-E0001\\\",\\\"detail\\\":\\\"No se encontró información relacionada con la consulta.\\\"}]}\",\"context\":\"default\"}") | parse content, """JSON:data""" | parse data[message], """LD ' -&gt; ' JSON:embedded_data""" | fields data[message], embedded_data[status]</LI-CODE><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mark_bley_0-1764278330104.png" style="width: 400px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/31038iA12177BBF8960224/image-size/medium?v=v2&amp;px=400" role="button" title="mark_bley_0-1764278330104.png" alt="mark_bley_0-1764278330104.png" /></span></P><P>&nbsp;</P> Thu, 27 Nov 2025 21:19:01 GMT mark_bley 2025-11-27T21:19:01Z https://community.dynatrace.com/t5/DQL/Parse-JSON-Data-Using-DQL-for-Advanced-Querying/m-p/290269#M2823 <P>Could you help me parse this log?</P> <PRE><SPAN class=""> },<BR />"logger" : "******************",<BR />"message" : "Detalle error respuesta API, nit real ********02464,fecha inicial 2025-11-21 , fecha final 2025-11-23 página 0 . Datos cuenta: [**********] -&gt; {\"meta\":{\"_messageId\":\"**************\",\"_requestDateTime\":\"2025-11-25T07:09:51.993-05:00\",\"_applicationId\":\"6***c2\"},\"status\":404,\"title\":\"Not Found\",\"errors\":[{\"code\":\"BPQR-E0001\",\"detail\":\"No se encontró información relacionada con la consulta.\"}]}",<BR />"context" : "default"<BR />}{<BR /><BR /></SPAN></PRE> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="yeyelka5_0-1764107642351.png" style="width: 400px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/31003iD077B3ACDCA70438/image-size/medium?v=v2&amp;px=400" role="button" title="yeyelka5_0-1764107642351.png" alt="yeyelka5_0-1764107642351.png" /></span></P> <P><SPAN>I would like to extract the "message" and "status" using a DQL query.</SPAN><SPAN class=""><BR /></SPAN></P> Wed, 17 Dec 2025 12:18:51 GMT https://community.dynatrace.com/t5/DQL/Parse-JSON-Data-Using-DQL-for-Advanced-Querying/m-p/290269#M2823 yeyelka5 2025-12-17T12:18:51Z https://community.dynatrace.com/t5/DQL/Parse-JSON-Data-Using-DQL-for-Advanced-Querying/m-p/290423#M2830 <P>something like this could work:</P><LI-CODE lang="markup">data record(content="{\"logger\":\"**************\",\"message\":\"Detalle error respuesta API, nit real ********02464,fecha inicial 2025-11-21 , fecha final 2025-11-23 página 0 . Datos cuenta: [] -&gt; {\\\"meta\\\":{\\\"_messageId\\\":\\\"**\\\",\\\"_requestDateTime\\\":\\\"2025-11-25T07:09:51.993-05:00\\\",\\\"_applicationId\\\":\\\"6*c2\\\"},\\\"status\\\":404,\\\"title\\\":\\\"Not Found\\\",\\\"errors\\\":[{\\\"code\\\":\\\"BPQR-E0001\\\",\\\"detail\\\":\\\"No se encontró información relacionada con la consulta.\\\"}]}\",\"context\":\"default\"}") | parse content, """JSON:data""" | parse data[message], """LD ' -&gt; ' JSON:embedded_data""" | fields data[message], embedded_data[status]</LI-CODE><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mark_bley_0-1764278330104.png" style="width: 400px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/31038iA12177BBF8960224/image-size/medium?v=v2&amp;px=400" role="button" title="mark_bley_0-1764278330104.png" alt="mark_bley_0-1764278330104.png" /></span></P><P>&nbsp;</P> Thu, 27 Nov 2025 21:19:01 GMT https://community.dynatrace.com/t5/DQL/Parse-JSON-Data-Using-DQL-for-Advanced-Querying/m-p/290423#M2830 mark_bley 2025-11-27T21:19:01Z