Unable to see the Json data as fields in kibana

[Chandana (Chandana Priya Sathavalli)]

I have a sample log file with json content

{ LoanCode:99356, LoanDate:3/2/2018, LoanStatus:OPN}

Here is my logstash conf file

input{
	file{
		path => "D:/elkstack/*.log"
		start_position => beginning
	}
}

filter{
	grok{
		match => { "message" => "%{GREEDYDATA:kvpairs}"  }		
	}
		json{
			source => "kvpairs"
			}  
	}
}

output{
	elasticsearch{
		hosts => "localhost:9200"
		index => "logstash-%{+YYY.MM.dd}"
	}
}

I need to create visualization over the values in the log eg. how many loans are OPN .
I am unable to see these key value pairs in the kibana as fields.

Here is the screen shot of Kibana

[Christian_Dahlqvist]

@Chandana

grok{ match => { "message" => "%{GREEDYDATA:kvpairs}" } } json{ source => "kvpairs" } }

This doesn't make any sense as it just copies over the full content of the field and the content isn't valid JSON. Instead try something like this:

grok{
  match => { "message" => "{ %{GREEDYDATA:kvpairs}}"  }		
} 

kv {
  source => "kvpairs"
  value_split => ":"
  field_split_pattern => ", "
}

[Chandana (Chandana Priya Sathavalli)]

Many thank @Christian_Dahlqvist !!

I tried with your suggestion, it almost worked but I see '}' in the field names.
Can you help me how to avoid them? Do I have to make any changes to the log file pattern?

[Christian_Dahlqvist]

I modified the grok expression to remove those from the kvpairs string. It looks like you are still using your old pattern.

[Chandana (Chandana Priya Sathavalli)]

My Bad
I was using my old pattern.

When I changed with your code, it worked as expected.

Thank you @Christian_Dahlqvist. You really made my day.