I'm looking for breaking following nested JSON file and transform it into a SQL prepared format.   Input JSON file:       { "Product1": { "Purchase": 31 }, "Product2": { "Purchase": 6213, "Cancel": 1988, "Change": 3702, "Renewal": 5934 } }       Desired output:        [ { "product": "Product1", "Purchase": 31 }, { "product": "Product2", "Purchase": 6213, "Cancel": 1988, "Change": 3702, "Renewal": 5934 } ]     ... View more

I'm looking for breaking nested JSON file and try to flat it to fit into a SQL database.   Current Json:   { "content": { "failedPerProductLineAndReason": { "Product1": { "Downsizing licenses is not allowed": 1 } } } }    Expected outcome:  { "ErrorType" : "failedPerProductLineAndReason" , "product" : "Product1" , "error" : "Downsizing licenses is not allowed" , "quantity" : 1 }   ... View more

I wanted to wait until 'ExecuteSQL' processor finishes inserting big file into SQL database (table: bu_service_template), then move to other section. 'ExecuteSQL' processor inserts row by row content of a file. I wanted to wait until file is fully inserted and then move to a next file. My current flow: wait flow ... View more

How can I break and flatten nested JSON with arrays using Jolt transformations from:       { "product": [ "data - 1", "data - 2" ], "Purchase": [ 2, 2 ], "Renewal": 1 }         to         [ { "product": "data -1", "Purchase": 1, "Renewal": 1 }, { "product": "data -2", "Purchase": 2, } ]         My current jolt transformation doesn't give me fully accurate transformation         [ { "operation": "shift", "spec": { "*": { "*": { "@": "[#2].&2" } } } } ]         ... View more