question Re: JSON file with operation values ADD/MODIFY based on this I need to send JSON data to INSERT or UPDATE in Support Questions

JSON file with operation values ADD/MODIFY based on this I need to send JSON data to INSERT or UPDATE

MPraveen — Mon, 23 Mar 2020 01:05:05 GMT

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

Re: JSON file with operation values ADD/MODIFY based on this I need to send JSON data to INSERT or UPDATE

stevenmatison — Mon, 23 Mar 2020 19:05:50 GMT

After you get all the attributes you want, you check them with RouteOnAttribute. In that proc click + and set update / inserts equal to matches you want. You use regex in the value for each. For example insert is ${operation.equals('add')}. After RouteOnAttribute is configured, drag update to the update query proc, and insert to the insert query proc.

Re: JSON file with operation values ADD/MODIFY based on this I need to send JSON data to INSERT or UPDATE

MPraveen — Thu, 26 Mar 2020 01:48:47 GMT

Thanks @stevenmatison . worked perfectly..