Hi guys! I have json like that: { "id" : "20", "user" : { "name" : "John", "date" : "" } } I transform this date to Long using nifi langugage ${date:isEmpty():ifElse('',${date:toDate('yyyy-MM-dd HH:mm:ss'):toNumber()})} and after this i do in jolttrasformation something like [ { "operation": "shift", "spec": { "idTransakcji" : "id", "date": "user.date", } }, { "operation": "modify-overwrite-beta", "spec": { "user": { "date": "=toLong(@(1,date))" } } } ]  and it works. But I have problem beacause when I have emptyString in this date i need to transfer it in null(not null in String) and i dont know how to do it using JoltTransformation or something else  so as not to lose what I already have and have null only when there is an empty string.   ... View more

Hi guys! i have some problems with JoltTransformation in NIFI. I have plain json like that: { "id": "c47f79f5-77b1-45d1-91df-968c2fa3def8", "system" : "OP", "sourceSystem" : "DKG", "name" : "Agnes", "lastName" : "Smith", "mail" : "a.smith@gmail.com", "country" : "Australia", "city" : "Sydney", "street" : "Colorado", "building" : "23", "local" : "1', "paycheck" : "3456,98', "joiningDate" : "12-09-2023", "isOfAge": "true", } And i need to have output like this: { "paycheck":3456.98, "joiningDate":1702048486451, "person":{ "name":"Agnes", "lastName":"Smith", "mail":"a.smith@gmail.com", "isOfAge":true, "adress":{ "country":"Australia", "city":"Sydney", "street":"Colorado", "building":"23", "local":"1" } }, "system_data":{ "id":"c47f79f5-77b1-45d1-91df-968c2fa3def8", "system":"OP", "sourceSystem":"DKG" } } In addition to nesting, I need to convert date to long, paycheck to double and isOfAge to boolean.I tried use JoltTransformation and Jolt Specification like this: [ { "operation":"shift", "spec":{ "paycheck":"paycheck", "joiningDate":"joiningDate", "name" : "person.name", "lastName" : "person.lastName", "mail" : "person.mail", "isOfAge" : "person.isOfAge", "country" : "person.adress.country", "city" : "person.adress.city", "street" : "person.adress.street", "building" : "person.adress.building", "local" : "person.adress.local", "id" : "system_data.id", "system" : "system_data.system", "sourceSystem" : "system_data.sourceSystem" } }, { "operation": "modify-overwrite-beta", "spec": { "paycheck": "=toDouble", "joiningDate": "=toNumber", "isOfAge": "=toBoolean" } } ]   Nesting works but type conversion not. What am I doing wrong because i admit that jolt is little bit complicated for me  ... View more