I am very new to NiFi, and I'm attempting to set up a very simple process to convert a CSV file to JSON. When the file comes in, I take the file name and use ExecuteSQL to look up some processing instructions, like the destination directory for the final output.
GetFile - everything looks fine if I view content in data provenance. It's the contents of the CSV file.
ExecuteSQL - everything looks fine if I view content in data provenance.
ConvertAvroToJSON - I'm converting the result of the query to JSON so I can use it to set variables. This is where I lose the content of the original file. Which I guess is reasonable, but I have no idea how to keep the original content.
I hope this makes sense. If I can figure out how, I'll add images.