How to parse the JSON Column dynamically using logstash

Elastic Stack Logstash
1

Hi All

I have a RESTful API (given below), when i index it , i get only 1 column in Elasticsearch as "message"

http://samples.openweathermap.org/data/2.5/weather?q=London,uk&appid=b1b15e88fa797225412429c1c50c122a1

I need to parse this message into multiple columns like main, description, icon,temp, presssure, humidity.....etc.

All this i get in JSON response, all should act as Field/Column in Kibana.

Is there anyway wherein we can get always lowest level field value using logstash?

2

anyone has done something like this?

i believe this is a common problem in all json respone.