https://community.cloudera.com/t5/Support-Questions/How-to-get-specific-fields-from-Json-in-Nifi/m-p/242324#M204127 <P>I solved the problem. I used this solution;</P><PRE>[ { "operation": "shift", "spec": { "*": { "nodeId": "node_ids", "status": "node_status" } } } ]</PRE> Thu, 17 Jan 2019 03:21:41 GMT sosyalmedya_ogu 2019-01-17T03:21:41Z https://community.cloudera.com/t5/Support-Questions/How-to-get-specific-fields-from-Json-in-Nifi/m-p/242323#M204126 <P>I have nifi cluster summarry json data like this;</P><PRE>[{ "nodeId": "29bed24c-6d73-4652-930b-0065cad4ef66", "address": "b1518aec7e38", "apiPort": 8080, "status": "CONNECTED", "heartbeat": "01/16/2019 16:24:32 UTC", "roles": ["Primary Node", "Cluster Coordinator"], "activeThreadCount": 0, "queued": "0 / 0 bytes", "events": [{ "timestamp": "01/16/2019 15:21:50 UTC", "category": "INFO", "message": "Received first heartbeat from connecting node. Node connected." }, { "timestamp": "01/16/2019 15:21:48 UTC", "category": "INFO", "message": "Connection requested from existing node. Setting status to connecting." }], "nodeStartTime": "01/16/2019 15:20:44 UTC" }, { "nodeId": "22aofpp4-87rf-asf4-930b-0065cad4ef66", "address": "b67uf98tkl5", "apiPort": 8080, "status": "CONNECTED", "heartbeat": "01/16/2019 16:24:32 UTC", "roles": [], "activeThreadCount": 0, "queued": "0 / 0 bytes", "events": [{ "timestamp": "01/16/2019 15:21:50 UTC", "category": "INFO", "message": "Received first heartbeat from connecting node. Node connected." }, { "timestamp": "01/16/2019 15:21:48 UTC", "category": "INFO", "message": "Connection requested from existing node. Setting status to connecting." }], "nodeStartTime": "01/16/2019 15:20:44 UTC" }]</PRE><P>I want only nodeId and status fields from this json. Output what i want;</P><PRE>{ "nodeIds": ["node1Id", "node2Id"], "status": ["node1Status", "node2Status"] }</PRE><P>For example output what i want;</P><PRE>{ "nodeIds": ["29bed24c-6d73-4652-930b-0065cad4ef66", "22aofpp4-87rf-asf4-930b-0065cad4ef66"], "status": ["CONNECTED", "CONNECTED"] }</PRE><P>But I couldn't do Jolt Specification for this. How can i do this?</P> Thu, 17 Jan 2019 03:21:40 GMT https://community.cloudera.com/t5/Support-Questions/How-to-get-specific-fields-from-Json-in-Nifi/m-p/242323#M204126 sosyalmedya_ogu 2019-01-17T03:21:40Z https://community.cloudera.com/t5/Support-Questions/How-to-get-specific-fields-from-Json-in-Nifi/m-p/242324#M204127 <P>I solved the problem. I used this solution;</P><PRE>[ { "operation": "shift", "spec": { "*": { "nodeId": "node_ids", "status": "node_status" } } } ]</PRE> Thu, 17 Jan 2019 03:21:41 GMT https://community.cloudera.com/t5/Support-Questions/How-to-get-specific-fields-from-Json-in-Nifi/m-p/242324#M204127 sosyalmedya_ogu 2019-01-17T03:21:41Z