Hi
I am new to NiFi, but I am trying to process an array of JSON data that I wish to then pass on for input to an Oracle Store Procedure.
However, there is an element in each array that holds data that is unstructured which has newline characters.
What I have been able to do with the data is to use the ReplaceText processor to remove the newline characters with nothing, and tried Evaluate JSON and Attributes to Json to try and restructure the data into new elements in the array. Unfortunately, I have not been able to get anything to work.
Is there a process that can help this?