Generic JOLT spec for multiple input JSON

[ramesh04301]

I m having difficulty in writing a jolt spec for different JSON inputs.

Input 1 - [ { "OrderInfo": [ { "OrderHeader": { "orderType": "PULL", "customerPOType": "", "enteredDate": "20220324190249", "mitSect": "", "mitBillingFacility": "", "customerCode": "Z177", "mitAccNo": "", "userCWSId": "ANDERM2", "userName": "Michael Andersen", "rushFlag": 0, "customerPONumber": "", "mitPriorityIndicator": "", "mitOrderNumber": "", "customerFacilityCode": "JA", "GSIOrderNumber": "SHIVAM1000000100", "dtCode": "JADOJA", "mitRemarks": "" }, "OrderDetails": [ { "deliverToCoordinates": " SUPRA2RA", "exactQuantityFlag": "", "earlyShipDate": "20220324190249", "deliverToDockBuilding": "JA", "preferredWarehouseId": "SE92", "deliverToBuilding": "A2", "deliverToDropZoneArea": " A2A", "orderQuantity": 100, "orderMethod": "P", "plannedFirmIndicator": "F", "transactionType": "A", "lateShipDate": "", "crossdockFlag": 0, "deliverToArea": " A2A", "partNumber": "2T3001", "buildSequenceNumber": "", "deliverToDropZoneBuilding": "A2", "orderLineNumber": 1, "deliverToDockArea": "DOJA" } ] }, { "OrderHeader": { "orderType": "PULL", "customerPOType": "", "enteredDate": "20220324190249", "mitSect": "", "mitBillingFacility": "", "customerCode": "Z177", "mitAccNo": "", "userCWSId": "ANDERM2", "userName": "Michael Andersen", "rushFlag": 0, "customerPONumber": "", "mitPriorityIndicator": "", "mitOrderNumber": "", "customerFacilityCode": "JA", "GSIOrderNumber": "SHIVAM1000000100", "dtCode": "JADOJA", "mitRemarks": "" }, "OrderDetails": [ { "deliverToCoordinates": " SUPRA2RA", "exactQuantityFlag": "", "earlyShipDate": "20220324190249", "deliverToDockBuilding": "JA", "preferredWarehouseId": "SE92", "deliverToBuilding": "A2", "deliverToDropZoneArea": " A2A", "orderQuantity": 100, "orderMethod": "P", "plannedFirmIndicator": "F", "transactionType": "A", "lateShipDate": "", "crossdockFlag": 0, "deliverToArea": " A2A", "partNumber": "2T3001", "buildSequenceNumber": "", "deliverToDropZoneBuilding": "A2", "orderLineNumber": 1, "deliverToDockArea": "DOJA" } ] } ] } ]

Input 2 -

[ { "OrderInfo": [ { "OrderHeader": { "orderType": "MCOE", "esoNumber": "TLVKK00", "rushFlag": "0", "serialNumber": "CA900319", "enteredDate": "20220110082146", "customerFacilityCode": "LE", "GSIOrderNumber": "DS0000000055068", "customerCode": "Z319" }, "OrderDetails": [ { "deliverToCoordinates": "S-X=ILCMC ", "exactQuantityFlag": "Y", "earlyShipDate": "20220110082146", "deliverToDockBuilding": "LE", "kanbanNumber": "SAMG 047877", "preferredWarehouseId": "", "deliverToBuilding": "B", "buildDate": "20211208000000", "deliverToDropZoneArea": "04M", "orderQuantity": 8, "startOnLineDate": "20211207000000", "warehouseId": "", "crossdockFlag": 0, "deliverToArea": "04M", "partNumber": "7K1181", "buildSequenceNumber": "012", "deliverToDropZoneBuilding": "B ", "orderLineNumber": 90, "deliverToDockArea": "DOCK" }, { "deliverToCoordinates": "S-X=ILCMC ", "exactQuantityFlag": "Y", "earlyShipDate": "20220110082146", "deliverToDockBuilding": "LE", "kanbanNumber": "SAMG 020472", "preferredWarehouseId": "", "deliverToBuilding": "B", "buildDate": "20211208000000", "deliverToDropZoneArea": "04M", "orderQuantity": 4, "startOnLineDate": "20211207000000", "warehouseId": "", "crossdockFlag": 0, "deliverToArea": "04M", "partNumber": "6V8398", "buildSequenceNumber": "012", "deliverToDropZoneBuilding": "B ", "orderLineNumber": 173, "deliverToDockArea": "DOCK" } ] } ] } ]

JSON Ouput Required -

Single Flattened JSON

[ { "GSIOrderNumber" : "SHIVAM1000000100", "Orderdetails.deliverToCoordinates" : " SUPRA2RA", "Orderdetails.exactQuantityFlag" : "", "Orderdetails.earlyShipDate" : "20220324190249", "Orderdetails.deliverToDockBuilding" : "JA", "Orderdetails.preferredWarehouseId" : "SE92", "Orderdetails.deliverToBuilding" : "A2", "Orderdetails.deliverToDropZoneArea" : " A2A", "Orderdetails.orderQuantity" : 100, "Orderdetails.orderMethod" : "P", "Orderdetails.plannedFirmIndicator" : "F", "Orderdetails.transactionType" : "A", "Orderdetails.lateShipDate" : "", "Orderdetails.crossdockFlag" : 0, "Orderdetails.deliverToArea" : " A2A", "Orderdetails.partNumber" : "2T3001", "Orderdetails.buildSequenceNumber" : "", "Orderdetails.deliverToDropZoneBuilding" : "A2", "Orderdetails.orderLineNumber" : 1, "Orderdetails.deliverToDockArea" : "DOJA" } ]

Jolt Spec i Tried is working for Input 2 but not for Input 1

[{ "operation": "shift", "spec": { "": { "OrderInfo": { "": { "OrderDetails": { "": { "@(2,OrderHeader.GSIOrderNumber)": "[&].GSIOrderNumber", "": "[&1].Orderdetails\.&" } } } } } } } ]

Pls help