Support Questions
Find answers, ask questions, and share your expertise

JoltTransformJSON intermediate issue

JoltTransformJSON intermediate issue

Explorer

Hello, 

I want transform my JSON with additional information and hence used JoltTransformJSON. 

Input

{

  "data1" : "Value 1",

  "data2" : "Value 2",

  "data3" : "Value 3",

}

 

output after transformation 

{

  "data1" : "Value 1",

  "data2" : "Value 2",

"data3" : "Value 3",

 "Txn_Filename": "Inputfile.txt",
"Tnx_Date": "20-04-13-12-02-23",
"Tnx_Status": "Pending",
"Tnx_Response": "Awaited"
}

 

So i used JoltTransformationJSON using below spec 

{
"Txn_Filename": "${filename}",
"Tnx_Date": "${now():format("yyyy-MM-dd-HH-mm-ss")}",
"Tnx_Status": "Pending",
"Tnx_Response": "Awaited"
}

Jlottransformation.PNG

 

Issue is : Transformation is working intermediate. Sometime its works and sometime it does not . 

 

With the same input file when submitted, some time it adds the fields and some time it does not. 


The same behavior is seen during "removal " of transformation. (snapshot below)

 

Can anyone help me to resolve this intermediate issue. 

 

Jlotransformation Remove.PNG

Thanks 

Rups.