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?