# Extracting JSON key and values to separated fields

**URL:** <https://discuss.elastic.co/t/extracting-json-key-and-values-to-separated-fields/236289>\
**Category:** Logstash\
**Created:** [June 9, 2020, 8:58am UTC](https://discuss.elastic.co/t/extracting-json-key-and-values-to-separated-fields/236289 "2020-06-09T08:58:12Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![mihailo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mihailo/32/45680_2.png) [@mihailo](https://discuss.elastic.co/u/mihailo)\
**Post date:** [June 9, 2020, 12:13pm UTC](https://discuss.elastic.co/t/extracting-json-key-and-values-to-separated-fields/236289/2 "2020-06-09T12:13:51Z")

</div>

Solved.

```
filter {
    json {
        source => "message"
        target => "json"
    }
    if "_jsonparsefailure" not in [tags] {
        ruby {
            code => "
                json_data = event.get('[json]')
                event.set('url', json_data.keys[0])
                event.set('parameters', json_data[json_data.keys[0]])
            "
        }
        mutate { 
            remove_field => ["message"] 
            remove_field => ["json"] 
        }
    }
}

```

[This](https://discuss.elastic.co/t/getting-key-value-from-nested-event-element/107852) can help.

---

_[View the full topic](https://discuss.elastic.co/t/extracting-json-key-and-values-to-separated-fields/236289)._