Hi all, I tried to connect NiFi-Registry 0.3.0 with github following this description https://community.hortonworks.com/articles/210286/storing-apache-nifi-versioned-flows-in-a-git-repos.html It works as far so I can create a new bucket and start a new version control and all this appears in github-repository. BUT isn't it possible to get already existing buckets and versioned flows into the github-repository? Nothing of this was pushed to github so I turned the providers.xml back to before Do I get this right that the whole version control has to be set up new when connecting to github-repository? Read here: https://nifi.apache.org/docs/nifi-registry-docs/html/administration-guide.html#switching-from-other-flow-persistence-provider Thanks for any clarification! ... View more

Within a flow there have to be checked some things by making an InvokeHTTP returning the response in an attribute (RESPONSE). The content of this attribute looks like this (note: there can be as many entries): [{"id":"(1208)","datbis":"20190630"}, {"id":"(1210)","datbis":"20191231"}, {"id":"(1212)","datbis":null}] Now there are two things to check: 1. Does at least one entry "datbis" have equal null? 2. Does at least in one entry "datbis" be greater or equal todays date? Check 1 can be done with ${anyDelineatedValue("${RESPONSE:jsonPath('$..datbis')}", ","):contains("null")} Check 2 I can't finde a solution. Tried with spooky things like ${anyDelineatedValue("${RESPONSE:jsonPath('$..datbis'):toDate('yyyyMMdd'):format('yyyyMMdd')}", ","):ge(${now():format("yyyyMMdd")})} but it went wrong. 'Cannot parse attribute value as a date; date format: yyyyMMdd; attribute value: ["20190630","20191231","20190715"]' Could someone please provide some help? ... View more

Hi all, I'm still working on a solution for this problem https://community.hortonworks.com/questions/248972/nifi-script-for-json-content-manipulation-before-j.html Following the recommendation of @Rosa Negra I try to do this with record-processing along this article of @Shu (thanks for this) https://community.hortonworks.com/content/kbentry/189642/update-the-contents-of-flowfile-by-using-updaterec.html Input-JSON {   "user": "Justen",   "stand": "20190702121621",   "table": [     {       "zn": 1,       "elem_user": "Meier",       "elem_stand": "20190705081410",       "dnr": "(0)",       "group": "1"     },     {       "elem_stand": "20190706201918",       "zn": 2,       "elem_user": "Schmidt",       "dnr": "(0)",       "group": "2"     }   ] } Desired Output-JSON {         "user": "Justen",         "stand": "2019-07-02 10:16:21",         "table": [             {                 "zn": 1,                 "elem_user": "Meier",                 "elem_stand": "2019-07-05 06:14:10",                 "dnr": "(0)",                 "group": "1",                 "dnr_group": "V-00-01"             },             {                 "elem_stand": "2019-07-06 18:19:18",                 "zn": 2,                 "elem_user": "Schmidt",                 "dnr": "(0)",                 "group": "2",                 "dnr_group": "V-00-02"             }         ]     } actual Output-JSON of my flow [ {   "name" : "Justen",   "stand" : "2019-07-02 10:16:21.000",   "table" : [ {     "zn" : 1,     "elem_user" : "Meier",     "elem_stand" : "2019-07-05 06:14:10.000",     "dnr" : "(0)",     "group" : "1",     "dnr_group" : "(0)(0)12"                   ========> first expected "(0) 1"; ideal case "V-00-01"   }, {     "zn" : 2,     "elem_user" : "Schmidt",     "elem_stand" : "2019-07-06 18:19:18.000",     "dnr" : "(0)",     "group" : "2",     "dnr_group" : "(0)(0)12"                   ========> first expected "(0) 2"; ideal case "V-00-02"   } ] } ] I had success with formatting the timestamps (stand, elem_stand)! But I can't find the rigt syntax for RecordPath setting "dnr_group". All examples here https://nifi.apache.org/docs.html in Apache NiFi RecordPath Guide don't show how to use functions working with elements of an array. In the second UpdateRecord (Change Value - Record Path) I tried "Property" /table[0..-1]/dnr_group for access on all elements which works, but at "Value" I don't know how to reference the elements dnr and group of the single entry. My aim is still to build this expression which works in EL... ${DNR:substringAfter('('):substringBefore(')'):toNumber()                            :lt( 10 )                                     :ifElse(${DNR:substringAfter('('):substringBefore(')'):prepend('0')},                                             ${DNR:substringAfter('('):substringBefore(')')})                            :append('-'):append(${GROUP:toNumber()                            :lt( 10 )                                     :ifElse(${GROUP:prepend('0')},                                             ${GROUP})})    :prepend('V-')} Please have a look on the attachment which shows anything I defined in NiFi. Thanks for any help! ... View more

Hi all, as far as I investigated this (https://community.hortonworks.com/questions/247330/nifi-need-help-with-jolt-syntax-jolttransformjson-1.html) it is not possible to do this with JOLT. Now I want to manipulate the JSON-content BEFORE JOLT does simple transformation. I'm getting used to do some things with groovy, viewed some examples but couldn't find the right syntax. There are two things I need to to: 1. All timestamps from JSON have to be converted and formated from CET yyyyMMddHHmmss ==> to UTC yyyy-MM-dd HH:mm:ss.SSS 2. Some string manipulation with some kind of expression language doing this: Expression Language to build "dnr_group"    ${DNR:substringAfter('('):substringBefore(')'):toNumber() :lt( 10 )                             :ifElse(${DNR:substringAfter('('):substringBefore(')'):prepend('0')},                                     ${DNR:substringAfter('('):substringBefore(')')})                             :append('-'):append(${GROUP:toNumber() :lt( 10 )                                     :ifElse(${GROUP:prepend('0')},                                         ${GROUP})})     :prepend('V-')} Input-JSON {   "user": "Justen",   "stand": "20190702121621",   "table": [     {       "zn": 1,       "elem_user": "Meier",       "elem_stand": "20190705081410",       "dnr": "(0)",       "group": "1"     },     {       "elem_stand": "20190706201918",       "zn": 2,       "elem_user": "Schmidt",       "dnr": "(0)",       "group": "2"     }   ] } Desired Output-JSON     {         "user": "Justen",         "stand": "2019-07-02 10:16:21",         "table": [             {                 "zn": 1,                 "elem_user": "Meier",                 "elem_stand": "2019-07-05 06:14:10",                 "dnr_group": "V-00-01"             },             {                 "elem_stand": "2019-07-06 18:19:18",                 "zn": 2,                 "elem_user": "Schmidt",                 "dnr_group": "V-00-02"             }         ]     } Is it possible to do this with groovy or does anybody know other ways manipulating JSON-content in NiFi? Thanks for any help! ... View more