Hi I want to use the PutSQL processor to execute an insert statement. The use case is straightforward. I need to pull an id attribute from a JSON message and write it to a database. I am using EvaluateJSONPath to grab the id but I’m hung up on how to then pass the SQL statement as the content. I could put the SQL statement in a file to be loaded as content but I am wondering if there is a way to do this inline with the flow? Ideally I would have the content of the FlowFile be the SQL and pass in the id as a SQL parameter as mentioned in the documentation.
Thanks for your help, Ralph
