# Get value from json object **URL:** \ **Category:** Kibana\ **Created:** [March 20, 2020, 5:10am UTC](https://discuss.elastic.co/t/get-value-from-json-object/224347 "2020-03-20T05:10:41Z")\ **Posts on this page:** 1\ **Showing post:** 8
**Author:** ![lukeelmers](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukeelmers/32/35230_2.png) [@lukeelmers](https://discuss.elastic.co/u/lukeelmers)\ **Post date:** [March 26, 2020, 7:53pm UTC](https://discuss.elastic.co/t/get-value-from-json-object/224347/8 "2020-03-26T19:53:12Z")
> [@Avend544](#): > > Can u give a link to the all method supported in the Painless [The painless specification](https://www.elastic.co/guide/en/elasticsearch/painless/current/index.html) and [the painless API reference](https://www.elastic.co/guide/en/elasticsearch/painless/7.6/painless-api-reference.html) should have the information you are looking for. > [@lukeelmers](#): > > If so, that's most likely your problem -- you'll need to parse that string in your scripted field first (which isn't going to be very performant). My bad, but I just realized I was mistaken in this comment above -- I forgot that painless doesn't actually allow JSON parsing in its API. (In part because it would be really terrible from a performance perspective as I mentioned). So your best bet is going to be parsing those `message` strings to objects at ingest time as stated in the comment above... these two threads have more on this topic: - [How to convert a json format string to json object using painless script kibana](https://discuss.elastic.co/t/how-to-convert-a-json-format-string-to-json-object-using-painless-script-kibana/210684) - [Painless scripting JSON functions](https://discuss.elastic.co/t/painless-scripting-json-functions/98511) The only other alternative I can think of would be [regex matching for a substring](https://discuss.elastic.co/t/substring-in-painless/88660/3), which is also going to slow things down, and definitely isn't considered a best practice for a situation like this. --- _[View the full topic](https://discuss.elastic.co/t/get-value-from-json-object/224347)._