I have extracted below json from my executesql processor: { "Id" : "B2606868-F4BC-4230-9749-A083F6D222B2", "ReminderPlan" : "-5d, -1d'", "ModifiedOn" : "2024-01-03 19:56:59.0000000" } and I have several of these. The task at my hand is to extract the reminderplan value and pass it as an attribute to some sql processor and run a sql function on that reminderplan column value; for example:  DECLARE @output varchar(255); SET @output = NewDemo.dbo.StandardizeReminderPlan('-5d, -1d') SELECT @output AS Result; After storing output value in Result, I want to insert the function value back in the same json. Could anyone suggest which processors I should use to accomplish this? ... View more

I am trying to access a .py file present in one of the docker container and I am using execute stream command processor for it. However, I am receiving "Permission Denied" error on the .py file.  Even though, the file has all the rights given but still facing this issue. Any feedback will be appreciate. Thanks.      ... View more

Hi all. I have two avro-binary types of flow files and their content is: Flow file one: [ { "DepartmentID" : "Undefined", "Name" : "Non Billable", } ]   Flow file two:[ { "DepartmentID" : "Null", "Name" : "Tax", } ] I am using UpdateRecord processor to add a key:value (tenantId) in the same file for which I am using below avro schema: { "name": "nifi", "type": "record", "fields": [ { "name": "TenantId", "type": ["null","string"] }, { "name": "DepartmentId", "type": ["null","string"] }, { "name": "Name", "type": ["null","string"] } ] } I am using literal value replacement value strategy and getting TenantId from previous processors. So far, this is a success and tenantId is appended. However, as a result, the DepartmentId changes to null for BOTH the files. Where I can ensure that the DepartmentId's values are not changed because based on these values, I have to route the "undefined" file for further processing.  Any help would be appreciated. Thanks.  ... View more