Its a script processor to run a groovy script. If a functional error is detected, I need to send original input file over FTP. ... View more

Sorry for my late post, Yes like you said @SAMSAL  I miss the parameter from connection string : this is my previous connection string jdbc:sqlserver://#{db_cmk_colo_host};port=#{db_cmk_colo_port};database=#{db_cmk_colo_name} And this is after (its working now) jdbc:sqlserver://#{db_cmk_colo_host};port=#{db_cmk_colo_port};database=#{db_cmk_colo_name};authentication=NotSpecified;encrypt=true;trustServerCertificate=true  Thank you again for your help. 😊 ... View more

@SAMSAL , After i added escaping to $ with double slash it got worked in shift too. "#\\${netval}": "&3[&2].&1"   thanks a lot again   ... View more

@coelacanth, My pleasure! Im glad it worked . If you find a better way than having to manually create the bin folder then copy the files from the script folder to it and restarting nifi every time you add new python processor or create the bin folder, please let us know and share. Right now for every python processor I create I have to restart my nifi instance 2 times: 1- Deploy the processor to the canvas so that the venv is created. 2- After the venv is created to copy the files to the bin folder. I know  its possible to create vevn manually under the work folder and get it setup without relying much on Nifi to do it but Im afraid that might interfere with the process and cause other problems. @pvillard, @MattWho , @cotopaul  please if you know better workaround for this let us know.     ... View more

Hi @saquibsk , The UpdateRecord processor uses the Nifi Record Path syntax to traverse record structure : https://nifi.apache.org/docs/nifi-docs/html/record-path-guide.html When your Replacement Value Strategy is set to Record Path Value then the path has to adhere to the record path syntax as explained in the link.  The record path allows you to update structured data even if you have more than one record in an array of records. Please see the documentation here as well for more help: https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-standard-nar/1.7.1/org.apache.nifi.processors.standard.UpdateRecord/additionalDetails.html If you are having more issues it would help to provide sample input and the expected output result alongside the relevant processors configuration screenshot. This will enable the community to help you better and resolve your issue faster. If you find this is helpful please accept  solution. Thanks ... View more

Hi @piyush7829 , Glad it worked and you were able to do the post. If I understood your question correctly then you need to pass the series_id to the post:form:series_id multipart form property dynamically, right? If that is the case then its easy since the InvokeHttp multipart dynamic properties allows for expression language you can reference the series_id attribute you have extracted using the EvaluateJsonPath and assign it as follows: post:form:series_id: ${series_id} Every time the invokeHttp is triggered it would evaluate the series_id expression from the incoming flowfile and assign its value before making the api invokation. Hope that helps.   ... View more

Thank you @SAMSAL , I tried using JOLT, but when it didn't work, I resorted to using the UpdateRecords process. However, this is ultimately what I need. ... View more

Hi @cotopaul , Thanks for your help. Actually you are right. Im not sure what I was thinking when I posted this or under what circumstances I was getting this error but I retried what I posted and it work so I apologize if I wasted your and the community time. However, what if I want to store the schema in the ValidateRecord processor itself as I would think that would be the proper way to use. Notice how in that processor there is no such field for setting the Date\Time format , and if I provide my schema to it by setting (Use Schema Text Property) I dont get an error but my flowfile goes to the "invalid" relationship complaining that the dob filed doesnt have the valid type!     In this case I did not use any schema def in the record reader\write but I kept the data format set to MM/dd/yyyy. Is there a way to fix this or am I using the processor the wrong way? Thanks again for your help.   ... View more