Solved
JSON file with operation values ADD/MODIFY based on this I need to send JSON data to INSERT or UPDATE
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


