@rupeshh , make a new post and describe your solution, then click Accept As Solution!!    Then this post will be available in future for anyone experiencing similar.   Great job getting it rectified! ... View more

@cotopaul This may be worthy of a JIRA and a fix.  PutBigQueryBatch is going away, so if there is some function missing in PutBigQuery we need to get it in there.    I just did some work on PutBigQuery, let me have a discussion with @davidh and I will get back to this asap.  If you can, share an example flow. ... View more

@TaxcalcRanjit I have a flow that demos how to take a CSV flowfile and format into html table.  That flow is here:   https://raw.githubusercontent.com/cldr-steven-matison/NiFi-Templates/main/CSV_to_Table_Demo.json   In this example I am using GenerateFlowfile to send some CSV data to a ReplaceText to replace the , (commas) with html code for separating each column in the table (</td><td>), and end of line and new line with html to end each row and start another ( </tr><tr>).  The end result is a full html table with the results of the csv as rows and columns.   You need to do something similar here to solve your use case to build the html source for your table's data.  I am not sure if your upstream flowfiles are all lines in one flowfile or one flowfile per result.   Either way you have to manipulate those flowfiles into html for the table structure matching your data    Once the flowfile is formatted correctly as html, then you can send to PutEmail. ... 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

@madhs @joseomjr A great example of the configuration is above.   Here is a full flow definition file/example showing how to get values from JSON and prepare ahead of an InvokeHTTP processor:     Flow Def File: https://raw.githubusercontent.com/cldr-steven-matison/NiFi-Templates/main/InvokeHttp_Demo_2.json ... 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

@Manimaran Wait/Notify should be able to do what you are describing in the deeper dialouge.   Based on your current flow complexity,  I would recommend that you build a new sample to learn how wait/notify behavior works in nifi.   This is very difficult setup, so having a learning flow w/o context of the existing functionality is highly optimal.   Then you can refactor your sql flow accordingly, without having to figure out how to get wait/notify working during that refactor. ... View more