Hi @SAMSAL , Am I missing something on the JOLT? Not getting output as expected. (DEFECT_ROOT_CUASE) columns is missing from output. ===========================================
--Input
===========================================
{
"id": "33414",
"fields": {
"customfield_10161": [
{
"value": "Backend"
},
{
"value": "Frontend"
}
]
}
}
===========================================
--JOLT Spec
===========================================
[
// Entries (where "flat" "data" when there is an array) (now starts at 8)
{
"operation": "shift",
"spec": {
"id": "INTEGRATION_ID",
"*": {
"*_*": {
"@": "&(1,1)",
"0": {
"#true": "isArray"
}
}
}
}
},
//If the input is not an array, assign default isArray=false
{
"operation": "default",
"spec": {
"isArray": "false"
}
},
//Depending on with isArray true for false
//Transpose values into DEFECT_ROOT_CAUSE_List_Array
{
"operation": "shift",
"spec": {
"customfield": null,
"*": "&",
"isArray": {
"true": {
"@(2,customfield)": {
"*": {
"value": {
"@": "DEFECT_ROOT_CAUSE_LIST[]"
}
}
}
},
"false": {
"@(2,customfield)": "DEFECT_ROOT_CAUSE_LIST[]"
}
}
}
},
// Finally, get the last element of the array
{
"operation": "modify-overwrite-beta",
"spec": {
"DEFECT_ROOT_CAUSE": "=lastElement(@(1,DIRECT_ROOT_CAUSE_LIST))"
}
}
]
===========================================
--Output
===========================================
{
"INTEGRATION_ID" : "33414",
"DEFECT_ROOT_CAUSE_LIST" : [ "Backend", "Frontend" ]
}
... View more
