Nifi: Use a value from message formatted in Avro to update a record in database

[#1]

Hello All,

I have an Avro message coming out of SplitAvro processor. This message contains a field and its value VAL. I want to run an update SQL against a database table as follows:

Update table X set Status='Processed' where ID = VAL;

How can I achieve this in NiFi?

Thanks!!

[#2]

I was able to accomplish this by using SplitAvro --> QueryRecord --> PutSQL