Parse JSON Array, header and body in different loop

Anonymous — Sat, 16 Nov 2024 02:11:39 GMT

How to parse this json? we need output like this

"RegistrationId","SurveyId","RegistrationIdCode","DEOCS_UploadStatus","RLSUserCode"
417,2,"KBR 6/4 #registration-fd0b45fe-4552-4f61-80df-db36bc107d94","Final","DEOCS_1AB07AA2-95C8-41EF-B109-343384339808"
417,2,"KBR 6/4 #registration-fd0b45fe-4552-4f61-80df-db36bc107d94","Final","DEOCS_F6A0327F-0954-4414-9677-44EB4D2305C7"

Input JSON

{
   "1709a4e1-30dc-4b72-8578-676ccd35c7c9":{
      "columnNames":[
         "RegistrationId",
         "SurveyId",
         "RegistrationIdCode",
         "DEOCS_UploadStatus",
         "RLSUserCode"
      ],
      "data":[
         [
            417,
            2,
            "KBR 6/4 #registration-fd0b45fe-4552-4f61-80df-db36bc107d94",
            "Final",
            "DEOCS_1AB07AA2-95C8-41EF-B109-343384339808"
         ],
         [
            417,
            2,
            "KBR 6/4 #registration-fd0b45fe-4552-4f61-80df-db36bc107d94",
            "Final",
            "DEOCS_A8605E0F-5E48-4A6C-AAD1-A591FFAA1217"
         ],
         [
            417,
            2,
            "KBR 6/4 #registration-fd0b45fe-4552-4f61-80df-db36bc107d94",
            "Final",
            "DEOCS_F6A0327F-0954-4414-9677-44EB4D2305C7"
         ]
      ],
      "samplingRatio":1.0,
      "totalRowCount":3,
      "rowCount":3,
      "pageSize":100000,
      "offset":0,
      "name":"Daload load validation"
   }
}

topic Parse JSON Array, header and body in different loop in Talend Studio

Parse JSON Array, header and body in different loop