I am facing an issue - in PutSQL I am sending a date value from XML-JSON->oracle table.   EvaluateJSOn ->RouteAttributes->AttributeJson->ConvertJsontoSQL -> UpdateAttrubites->PutSQL is my flow. But it is failing always with  ... View more

Eg: Update table table_name emp_name=? where empid=?   But My column name is emp_id ... View more

My file: "ws:Operation": "ADD", "ws:Supervisor_Name": { "ws:PriorValue": "", "content": "Dr. Leah Thaler"   In above example i need to send the content:Dr. Leah Thaler to insert  My file: "ws:Operation": "MODIFY", "ws:Supervisor_Name": { "ws:PriorValue": "", "content": "Dr. Leah Thal" In above example i need to send the content:Dr. Leah Thaler to update. Database is Oracle - the flow: Getfile-> EvaluateJSONPath -> send the data to two tables using AttributesToJSON for flatten JSON -> ConvertJSONSQL to Putsql.    Note: I dont want to write AVRO schema. So we build this flow  ... View more