Hi Team,   Need help. I have below two part.   1. merge the original Response with the API Response   Original response [{ "code": "100016", "Date": "2022-09-22" }, { "code": "100017", "Date": "2022-09-02" }, { "code": "100018", "Date": "2022-09-02" }, { "code": "100019", "Date": "2022-09-02" } ]   API Response: [{ "Record": "Record 3", "Description": "Processing failed due Internal Server Error." }, { "Record": "Record 4", "Description": "Processing failed due to error in record: 3" }]   Required output: { "RequestPayload": [{ "code": "100016", "Date": "2022-09-22" }, { "code": "100017", "Date": "2022-09-02" }, { "code": "100018", "Date": "2022-09-02" }, { "code": "100019", "Date": "2022-09-02" } ], "ApiResponse": [{ "Record": "Record 3", "Description": "Processing failed due Internal Server Error." }, { "Record": "Record 4", "Description": "Processing failed due to error in record: 3" }] }   After getting the above output I need to mapped the json objects as below input:   { "RequestPayload": [{ "code": "100016", "Date": "2022-09-22" }, { "code": "100017", "Date": "2022-09-02" }, { "code": "100018", "Date": "2022-09-02" }, { "code": "100019", "Date": "2022-09-02" } ], "ApiResponse": [{ "Record": "Record 3", "Description": "Processing failed due Internal Server Error." }, { "Record": "Record 4", "Description": "Processing failed due to error in record: 3" }] }   I am getting below output:   [ "{\"code\":\"100018\",\"Date\":\"2022-09-22\"}", "{\"code\":\"100019\",\"Date\":\"2022-09-02\"}" ]   Expected Output: [{ "code": "100018", "Date": "2022-09-22", "Record": "Record 3", "Description": "Processing failed due Internal Server Error."." }, { "code": "100019", "Date": "2022-09-02", "Record": "Record 4", "Description": "Processing failed due to error in record: 3" } ]   For that I am using below groovy Script: import org.apache.commons.io.IOUtils import java.nio.charset.StandardCharsets import groovy.json.* import java.util.ArrayList def flowFile = session.get() if(!flowFile) return try { flowFile = session.write(flowFile, { inputStream, outputStream -> def text = IOUtils.toString(inputStream, StandardCharsets.UTF_8) def obj = new JsonSlurper().parseText(text) def final1 = [] int j = obj.RequestPayload.size() for (int i=0;i<j;i++){ index = i+1 def rec = 'Record ' + index if (rec in obj.ApiResponse.Record){ final1.add(JsonOutput.toJson(obj.RequestPayload[i])) } } def response1 = JsonOutput.toJson(final1) outputStream.write(JsonOutput.prettyPrint(response1).getBytes(StandardCharsets.UTF_8)) } as StreamCallback) session.transfer(flowFile, REL_SUCCESS) } catch(Exception e) { log.error('Error during JSON operations', e) session.transfer(flowFile, REL_FAILURE) }   Can you please help. I am not familiar with groovy but i want to get the desired output with groovy script. Thanks in Advance        ... View more

I have below input:   [ { "seq_no": 18, "Id": 174052, "Date": "2021-12-26T00:00:00Z" }, { "seq_no": 19, "Id": 174052, "Date": "2021-12-26T00:00:00Z" } ]   Jolt Spec:   [ { "operation": "modify-overwrite-beta", "spec": { "*": { "seq_no": "=toString", "Date": "=substring(@(1,REVISION_IND),0,10)" } } }, { "operation": "shift", "spec": { "*": { "seq_no": "[&1].seq_no", "Id": "[&1].Id", "Date": "[&1].Date" } } }, { "operation": "shift", "spec": { "*": "data" } }, { "operation": "default", "spec": { "header": { "submit": "true", "comments": "3" } } } ]   Output: { "data" : [ { "seq_no" : "18", "Id" : 174052, "Date" : "2021-12-26T00:00:00Z" }, { "seq_no" : "19", "Id" : 174052, "Date" : "2021-12-26T00:00:00Z" } ], "header" : { "submit" : "true", "comments" : "3" } }   Desired Output:   { "header" : { "submit" : "true", "comments" : "3" }, "data" : [ { "seq_no" : "18", "Id" : 174052, "Date" : "2021-12-26T00:00:00Z" }, { "seq_no" : "19", "Id" : 174052, "Date" : "2021-12-26T00:00:00Z" } ] }   Can you please help how I will get the header part and then the data. I used sort but it's not helping me. Appreciate your help. Thank you. ... View more

Hi Team,   I have below requirement,   my flow file contains below data: [ { { "ID" : "100000", "Date" : "2022-09-22", "Start Time" : "08:00", "End Time" : "14:00", }, { "ID" : "100001", "Date" : "2022-09-02", "Start Time" : "08:00", "End Time" : "14:00", }, { "ID" : "100002", "Date" : "2022-09-02", "Start Time" : "08:00", "End Time" : "14:00", } } ]   [ {"res_data" : { "Record" : "Record 2", "Description" : "Invalid values for ID or Date" }, { "Record" : "Record 3", "Description" : "Invalid values for ID or Date" }} ]   And the requirement is: if concatenate ('Record' with index of array of json object == res_data.Record  then it should return { { "ID" : "100001", "Date" : "2022-09-02", "Start Time" : "08:00", "End Time" : "14:00", "Record" : "Record 2", "Description" : "Invalid values for ID or Date" } } and so on   else { "ID" : "100000", "Date" : "2022-09-02", "Start Time" : "08:00", "Time Out" : "14:00", "End Time" : "14:00", "Description": null }   and the final output looks like [ { "ID" : "100001", "Date" : "2022-09-02", "Start Time" : "08:00", "End Time" : "14:00", "Record" : "Record 2", "Description" : "Invalid values for ID or Date" }, { "ID" : "100002", "Date" : "2022-09-02", "Start Time" : "08:00", "End Time" : "14:00", "Record" : "Record 3", "Description" : "Invalid values for ID or Date" } ] I want to do it using groovy script but I don't know anything about the groovy script. Can you please help if anyone has done it before.   ... View more