# DQL parsing on JSON

**URL:** <https://community.dynatrace.com/t/dql-parsing-on-json/45934>\
**Category:** DQL\
**Tags:** dql\
**Created:** [June 5, 2024, 4:56pm UTC](https://community.dynatrace.com/t/dql-parsing-on-json/45934 "2024-06-05T16:56:48Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ae](https://avatars.discourse-cdn.com/v4/letter/a/d9b06d/32.png) [@ae](https://community.dynatrace.com/u/ae)\
**Post date:** [June 5, 2024, 4:56pm UTC](https://community.dynatrace.com/t/dql-parsing-on-json/45934/1 "2024-06-05T16:56:48Z")

</div>

I have this simple log:

Content{“HTTP\_REQUEST\_URL”: “…”,“HTTP\_RESPONSE\_CODE”: 500,“HTTP\_RESPONSE\_BODY”: “errors”,“CURRENT\_URL”: “/example”}I’m trying to get all the http status count that are above 400 example below, but not sure how it works with JSON?  
| parse content, “LD 'HTTP\_RESPONSE\_CODE ’ INT:httpstatus”  
| filter httpstatus \>= 400  
| summarize count(), by:{httpstatus}

---

<div class="post-metadata">

**Author:** ![mark\_bley](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/mark_bley/32/20954_2.png) [@mark\_bley](https://community.dynatrace.com/u/mark_bley)\
**Post date:** [June 6, 2024, 10:57am UTC](https://community.dynatrace.com/t/dql-parsing-on-json/45934/2 "2024-06-06T10:57:24Z")

</div>

you can easily parse json (mocked some of the data):

```markup
data record(content="{\"HTTP_REQUEST_URL\": \".....\",\"HTTP_RESPONSE_CODE\": 500,\"HTTP_RESPONSE_BODY\": \"errors\",\"CURRENT_URL\": \"/example\"}"),
record(content="{\"HTTP_REQUEST_URL\": \".....\",\"HTTP_RESPONSE_CODE\": 500,\"HTTP_RESPONSE_BODY\": \"errors\",\"CURRENT_URL\": \"/example\"}"),
record(content="{\"HTTP_REQUEST_URL\": \".....\",\"HTTP_RESPONSE_CODE\": 501,\"HTTP_RESPONSE_BODY\": \"errors\",\"CURRENT_URL\": \"/example\"}")
| parse content, "JSON:http_payload"
| filter http_payload[HTTP_RESPONSE_CODE] >= 400
| summarize count(), by:{http_payload[HTTP_RESPONSE_CODE]}

```

 ![mark_bley_0-1717671437191.png](https://global.discourse-cdn.com/dynatrace/original/3X/c/e/ceb307b202e94398d08c98590bfc18be7ea16cbf.png)
