@madhs  Have you resolved your issue. If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.            ... View more

@Ghilani You should know these 3 articles intimately if you want to use Execute Script   https://community.cloudera.com/t5/Community-Articles/ExecuteScript-Cookbook-part-1/ta-p/248922 https://community.cloudera.com/t5/Community-Articles/ExecuteScript-Cookbook-part-2/ta-p/249018 https://community.cloudera.com/t5/Community-Articles/ExecuteScript-Cookbook-part-3/ta-p/249148     That said, it's sometimes helpful for me to see a working example and modify from there.  As such, here is a github with a sample flow definition file (01_Fraud_Detection_Demo_Params_ExecuteScript.json) and script file(Fraud Demo ExecuteScript.py) that should work out of the box:   https://github.com/cldr-steven-matison/Fraud-Prevention-With-Cloudera-SSB/tree/main/Templates   Pay attention to imports and, then line 160 is what you want to get the flowfile.   My flow ignores the content, but you should be able to find references in the Part 1 cookbook for anything you want to do w/ flowfile content.           ... View more

@steven-matison thank you! I thought that I needed to somehow inject this jar into NiFi, in addition to providing it. ... View more

@bhadraka Check out this flow definition example for how to prepare and test JSON ahead of an invokeHttp post.   Flow Def File: https://raw.githubusercontent.com/cldr-steven-matison/NiFi-Templates/main/InvokeHttp_Demo_2.json     As far as the post itself goes.  I highly recommend that you test API calls with something like Postman so that you can clearly test what headers and such are required so that the API call works.  Only then try to make it work with InvokeHttp duplicating all headers.     Figuring out how to get the call to work and how to configure InvokeHTTP at same time is not fun. TIP:  in Invoke HTTP click the + to add key value pairs corresponding to your headers or values you need to pass.     ... View more

@Juanes I believe you just need to resolve the missing dependency.    Check out this solution: > pip3 install python-setuptools > yum install impala-shell https://community.cloudera.com/t5/Support-Questions/How-to-install-impala-shell-on-RHEL-8-3-to-communicate-with/m-p/313665   ... View more

@drewski7, in this case, have a look at @steven-matison 's answer because that is your solution to your problem. ... View more

@DTM In that case you would need to use the DatabaseConnectionPool and jdbc to aws postgres.  This will require permissions to allow nifi network to speak to RDS endpoint.  If you cant use DBCP,  you will have to put something between the RDS and nifi.  For example nifi could use invokeHTTP to send/post data to an ec2 instance with some kind of API that can do the connectivity. ... View more

@steven-matison    Thanks for link ... View more