How can I replicate this same solution with Apache NiFi v.1.23.1 today. The value for Request content type is default set to ${mime.type}     ... View more

Hi @SAMSAL @MaarufB, I had the same problem but solved it. The root cause was the CSRF security filter, which resulted in a 403 error. You can resolve this by setting the Request-Token header with the cookie value obtained during the access token issuance. For more details, please refer to the following link: NiFi Administration Guide - CSRF Protection Hope this helps! ... View more

Hi Shelton, Thanks very much for your help. I think this may be working. I'm going to continue testing it with the few of us who require access, but for now it's working from different browsers from my laptop. I had the certificates set up correctly from the start, and this setting seems to have done the trick. Thanks again for your reply and assistance! ... View more

@SAMSAL , This is indeed more efficient. Thanks for letting me know. ... View more

Thank you @SAMSAL (JOLT expert), The spec you posted worked properly and I'm able to see the flat JSON as expected. ... View more

Hi @SAMSAL , This works really fine. Thank you so much for your solution. I got your idea of splitting the JSON and perform the transformation in SQL table. I will work on that. Thank you again. ... View more

@PeterC Has the reply helped resolve 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. Thanks. ... View more

Thank you @SAMSAL . This is the issue, if i specify the external "Module Directory"  in the executescript , the ClassLoader somewhat clashed and no required class get loaded. So i have removed that and placed all my Jars into nifi/lib directory alone. Now it is working fine. Please let me know if any better way to handle that. Just not to use the nifi/lib directory. Also, let me try creating the custom processors to achieve this CSFLE.  ... View more

Hi Samsal, Firstly I want to thank you for taking your time in solving my query. The solution you provided worked like a magic. Secondly, yes I am new to this platform and also for JOLT, moving forward I will follow your tips and suggestions and will go through the courses which you've shared. Once again thank you for your valuable assistance. It made a significant difference. I am grateful.     ... View more

@SAMSAL  Solution worked like a charm, special thank you for additional hint on passing attribute to json payload.  Thank you. ... View more