I have the following JSON. I'd like to transform the JSON by extracting the "issued" field ("issued":"2018-10-17T20:16:00.000Z") and outputting a new JSON that preserves the existing JSON, but appends a new JSON that would contain a new property "issued_datetime":"2018-10-17T20:16:00.000Z". I'd also like to extract the effectiveStart and effectiveEnd and add them to the top level of the output JSON as well. So the output JSON would be the input JSON, with 3 properties added to it (replicas of issued, effectiveStart, effectiveEnd). Could someone please help me with the JOLT transform that would facilitate this. Input JSON: {
"textNOTAM": {
"NOTAM": {
"id": "NOTAM_1_51125176",
"number": 108,
"year": 2018,
"type": "N",
"issued": "2018-10-17T20:16:00.000Z",
"affectedFIR": "ZOA",
"minimumFL": "000",
"maximumFL": 999,
"radius": 5,
"location": "SCK",
"effectiveStart": 201810201100,
"effectiveEnd": 201811032000,
"schedule": "SAT SUN",
"text": "SVC PCL RWY 11L/29R REDL OUT OF SERVICE SAT SUN 1100-2000",
"translation": [
{
"NOTAMTranslation": {
"id": "NT01_51125176",
"type": "LOCAL_FORMAT",
"simpleText": "!SCK 10/108 SCK SVC PCL RWY 11L/29R REDL OUT OF SERVICE SAT SUN 1100-2000 1810201100-1811032000"
}
},
{
"NOTAMTranslation": {
"id": "NT02_51125176",
"type": "OTHER:ICAO",
"formattedText": {
"div": "10/108 NOTAMR \r\nQ) ZOA/QLEXX/IV/NBO/A/000/999/3753N12114W005 \r\nA) KSCK \r\nB) 1810201100 \r\nC) 1811032000 \r\n D) SAT SUN 1100-2000 \r\n\r\nE) \r\nSVC PCL RWY 11L/29R REDL PCL OUT OF SERVICE"
}
}
}
]
}
}
}
<br> Desired Output JSON: {
"issued":"2018-10-17T20:16:00.000Z",
"effectiveStart":201810201100,
"effectiveEnd":201811032000, {
"textNOTAM": {
"NOTAM": {
"id": "NOTAM_1_51125176",
"number": 108,
"year": 2018,
"type": "N",
"issued": "2018-10-17T20:16:00.000Z",
"affectedFIR": "ZOA",
"minimumFL": "000",
"maximumFL": 999,
"radius": 5,
"location": "SCK",
"effectiveStart": 201810201100,
"effectiveEnd": 201811032000,
"schedule": "SAT SUN",
"text": "SVC PCL RWY 11L/29R REDL OUT OF SERVICE SAT SUN 1100-2000",
"translation": [
{
"NOTAMTranslation": {
"id": "NT01_51125176",
"type": "LOCAL_FORMAT",
"simpleText": "!SCK 10/108 SCK SVC PCL RWY 11L/29R REDL OUT OF SERVICE SAT SUN 1100-2000 1810201100-1811032000"
}
},
{
"NOTAMTranslation": {
"id": "NT02_51125176",
"type": "OTHER:ICAO",
"formattedText": {
"div": "10/108 NOTAMR \r\nQ) ZOA/QLEXX/IV/NBO/A/000/999/3753N12114W005 \r\nA) KSCK \r\nB) 1810201100 \r\nC) 1811032000 \r\n D) SAT SUN 1100-2000 \r\n\r\nE) \r\nSVC PCL RWY 11L/29R REDL PCL OUT OF SERVICE"
}
}
}
]
}
}
}
}
... View more
