question Re: Groovy Script in ExecuteScript Processor To Format Date value from flow file in Support Questions

question Re: Groovy Script in ExecuteScript Processor To Format Date value from flow file in Support Questions https://community.cloudera.com/t5/Support-Questions/Groovy-Script-in-ExecuteScript-Processor-To-Format-Date/m-p/230208#M192058 Hi <A rel="user" href="https://community.cloudera.com/users/45268/rakesh999alla.html" nodeid="45268" target="_blank">@rakesh chow</A>, as ExecuteScripts are experimental in NiFi but you can acheive same results by using another processors as follows.<PRE>1.EvaluateJsonPath //Extract all the contents to attributes 2.UpdateAttribute //Update time stamps attributes with new format(yyyy-mm-dd hh...etc) 3.AttributesToJson //Recreate Json content by specifying all the attributes </PRE>EvaluateJsonPath configs:-My input sample content is<PRE>{ "ID":"1", "CID":"1", "DiscoveredTime":"Mon Sep 11 19:56:13 IST 2017", "LastDiscoveredTime":"Mon Oct 09 23:38:55 IST 2017" }</PRE>in eval json processor extract all the contents of the flowfile to the attributes of flowfile by changingDestination property to flowfile-attributeand add new properties by clicking + sign at right corner.ID <PRE>$.ID</PRE>DiscoveredTime <PRE>$.DiscoveredTime</PRE>CId <PRE>$.CId</PRE>LastDiscoveredTime <PRE>$.LastDiscoveredTime</PRE>so i have extracted all the content of ff as attributes of ff, in your case you need to add all your json content keys of contents here and this processor keeps all the values of content to attributes.Config Screenshot:-<img src="https://community.cloudera.com/t5/image/serverpage/image-id/15036i46BEDEA94DB6C5FE/image-size/medium?v=v2&px=400" role="button" title="39854-evaluatejson.png" alt="39854-evaluatejson.png" />UpdateAttribute Processor Configs:-This processor will helps to update the attributes on the fly we are changing our DiscoveredTime,LastDiscoveredTime attributes on the fly.add new properties 1.DiscoveredTime<PRE>${DiscoveredTime:toDate('EEE MMM dd HH:mm:ss ZZZ yyyy'):toNumber():plus(21600000):format("yyyy-MM-dd HH:mm:ss.SSS")}</PRE>in this expression we are checking which timezone it is and converting that to number and adding 6 hrs(i think you don't need to do :plus(21600000)), after that i'm converting to yyyy-MM-dd HH:mm:ss.SSS formatYour expression probably will be<PRE>${DiscoveredTime:toDate('EEE MMM dd HH:mm:ss ZZZ yyyy'):toNumber():format("yyyy-MM-dd HH:mm:ss.SSS")}</PRE>2. add new property for LastDiscoveredTime<PRE>${LastDiscoveredTime:toDate('EEE MMM dd HH:mm:ss ZZZ yyyy'):toNumber():plus(21600000):format("yyyy-MM-dd HH:mm:ss.SSS")}</PRE>Your expression:-<PRE>${LastDiscoveredTime:toDate('EEE MMM dd HH:mm:ss ZZZ yyyy'):toNumber():format("yyyy-MM-dd HH:mm:ss.SSS")}</PRE>Configs:-<img src="https://community.cloudera.com/t5/image/serverpage/image-id/15037iDAA2E9439A8258C5/image-size/medium?v=v2&px=400" role="button" title="39858-update-attr.png" alt="39858-update-attr.png" />AttributesToJson Processor:-in Attributes list property add all the available attributes it will prepare a json messages with the attributes that you have mentioned here.<PRE>ID,CID,DiscoveredTime,LastDiscoveredTime</PRE>Change Destination property to flowfile-contentConfigs:-<img src="https://community.cloudera.com/t5/image/serverpage/image-id/15038iFF6AF954FCBC7A3F/image-size/medium?v=v2&px=400" role="button" title="39859-attributestojson.png" alt="39859-attributestojson.png" />Input:-<PRE>{ "ID":"1", "CID":"1", "DiscoveredTime":"Mon Sep 11 19:56:13 IST 2017", "LastDiscoveredTime":"Mon Oct 09 23:38:55 IST 2017" }</PRE>Output:-<PRE>{ "ID" : "1", "LastDiscoveredTime" : "2017-10-09 23:38:55.000", "DiscoveredTime" : "2017-09-11 19:56:13.000", "CID" : "" }</PRE>In your case you need to mention all your attributes in attributes to json processor and it will prepare new json content with all your attributes, if you left this property as empty then all the attributes associated with the ff will be part of your json content.Flow Screenshot:-<img src="https://community.cloudera.com/t5/image/serverpage/image-id/15039iF2D28BE6EB9DE685/image-size/medium?v=v2&px=400" role="button" title="39860-flow.png" alt="39860-flow.png" /> Sun, 18 Aug 2019 00:49:27 GMT Shu_ashu 2019-08-18T00:49:27Z