Hi @justenji ! Please find the attached groovy code. Use it in ExecuteGroovyScript processor. import java.nio.charset.StandardCharsets import groovy.json.JsonSlurper import groovy.json.JsonOutput flowFile = session.get() if (!flowFile) return try { def jsonSlurper = new JsonSlurper(); def jsonOutput = new JsonOutput(); def input = flowFile.read().withStream { data -> jsonSlurper.parse(data) } def tables = input.table; for(int i=0;i<tables.size();i++){ def pattern = 'yyyyMMdd'; def datum = tables[i].datum; if(tables[i].containsKey('uhrzvon')){ pattern = pattern + 'HH:mm'; datum = datum + tables[i].uhrzvon; } tables[i].datum = new Date().parse(pattern,datum,TimeZone.getTimeZone('GMT+0200')).format('yyyy-MM-dd HH:mm:ss.SSSZ',TimeZone.getTimeZone('GMT')); } input.table = tables flowFile = session.write(flowFile, { outputStream -> outputStream.write(jsonOutput.toJson(input).toString().getBytes(StandardCharsets.UTF_8)) }as OutputStreamCallback) session.transfer(flowFile, REL_SUCCESS); } catch (e) { log.error('Error Occured,{}', e) session.transfer(flowFile, REL_FAILURE) } ... View more

Hi @Biswa! I tried various ways of getting a unique id for each array. Most of them failed. But, I tried to append the array index to the unique id. Even while doing it, I faced many issues. See if the below spec is okay [ { "operation": "shift", "spec": { "aliases": { "*": { "@0": "alias[&1].name", "$0": "alias[&1].id.${UUID()}-&1" } } } }, { "operation": "shift", "spec": { "alias": { "*": { "id": { "*": { "$0": "alias[&3].id" } }, "*": "alias[&1].&" } } } } ]    ... View more

Hi @ravi_sh_DS, I am perfectly getting the output after using the joltTransformRecord The spec I used is the same that you mentioned in your question. I don't think that the processor is converting the xml into json at first. Had it been that case, jolt must be acting on {  "note":{   "to":"...",   "from":"...",   "heading":"...",   "body":"..."  } } Even if the jolt is applied on the above json, your ouput will be empty json object. Can you check it once again? ... View more