Hi , My guess is that you are trying to use ConvertJsonToSQL & PutSQL to transpose the json into sql table. For this to happen you cant use the input json in the given format , you need to transform it using JoltTransformJSON processor to create an array of records where each record consist of "sbrActivityType" & "sbrDateTime" columns. The json keys have to match the table column names for this to work. The jolt spec to use can look like this: [
{
"operation": "shift",
"spec": {
"sbrActivityType": {
// convert every activity into an array element
"*": "data[#1].sbrActivityType"
},
"sbrDateTime": "sbrDateTime"
}
},
{
"operation": "modify-default-beta",
"spec": {
"data": {
"*": {
// create new sbrDateTime key under each array element from
// above and set its value to the initial sbrDateTime
"sbrDateTime": "@(3,sbrDateTime)"
}
}
}
}
] you set the Jolt Specification property with the spec above in the JoltTransformJSON This should give you new json flowfile as follows: {
"data" : [ {
"sbrActivityType" : "ACT+A",
"sbrDateTime" : "Sun Mar 19 13:45:15 AST 2023"
}, {
"sbrActivityType" : "ACT+X",
"sbrDateTime" : "Sun Mar 19 13:45:15 AST 2023"
}, {
"sbrActivityType" : "ACT+A",
"sbrDateTime" : "Sun Mar 19 13:45:15 AST 2023"
}, {
"sbrActivityType" : "ACT+X",
"sbrDateTime" : "Sun Mar 19 13:45:15 AST 2023"
}, {
"sbrActivityType" : "ACT+X",
"sbrDateTime" : "Sun Mar 19 13:45:15 AST 2023"
} ],
"sbrDateTime" : "Sun Mar 19 13:45:15 AST 2023"
} After that, use SplitJosn to split each record into its own json flowfile. The split JsonPath Expression is set to $.data.*: Then you use ConvertJSONToSQL as follows: And Finally you use the PUTSQL processor as follows: This should populate the table accordingly: If this helps please accept solution. Thanks
... View more
