question Re: Extract string nested in JSON value in Support Questions

Extract string nested in JSON value

vatodorov19 — Thu, 29 Oct 2020 21:55:48 GMT

UPDATE: If you ever need to modify a record use this solution: https://community.cloudera.com/t5/Support-Questions/NiFi-UpdateRecord-processor-is-not-updating-JSON-path/m-p/186256

ORIGINAL question:

How can I extract a string nested in the value of a JSON? For the status key below, I only want the value Active, instead of MapRecord[{current_status=Active}].

Original JSON

{ "indicator": "147.183.200.154", "timestamp": 1577742090000, "status": "MapRecord[{current_status=Active}]" }

Desired final JSON

{ "indicator": "147.183.200.154", "timestamp": 1577742090000, "status": "Active" }

Re: Extract string nested in JSON value

suraj143 — Sat, 31 Oct 2020 14:27:51 GMT

Refer the following template

https://drive.google.com/file/d/1e1q8xm-65WHHwGNsxyeRUSkRIw7ETO4B/view?usp=sharing

Re: Extract string nested in JSON value

vatodorov19 — Mon, 02 Nov 2020 13:32:49 GMT

Thanks @suraj143

I ended up using an UpdateRecord, but your approach with a JoltTransformJSON also works.