Treat string as JSON

I have JSON stored in an Oracle database as a CLOB (serialised JSON string). I'd like to get this into Elasticsearch as a JSON object.

I have the input specified as jdbc (with the oracle connection string etc) and the output as elasticsearch. The problem is that the JSON is being stored in ES as one big string. I assume I need to do some kind of filter, I'm just not sure where to start?

Any help is greatly appreciated.


I would suggest starting with the json filter :slight_smile:

Seems like a good suggestion to me :slight_smile:, thank you!

I've just been trying to parse the JSON only to find the data in the DB isn't actually valid :grimacing: