@MattWho    Thank you very much, this worked perfectly for what I was needing.   Can you tell me if this same flow also works with windows? ... View more

There should be two controllers configured:   DistributedMapCacheClientService DistributedMapCacheServer Client is, eh, client, server is a backend for your cache. Without server client has nowhere to send a flowfile. ... View more

@Matt    thank you very much for all the answer.   We are still insisting on getting the Base64 field from Oracle because the PDF is already there. I'm using the Base64EncodeContent process to decode the Base64 field coming from Oracle.   I was able to send a file to the E-mail with PDF format, but it still has an error when opening the PDF file sent in the E-mail.   It seems to me that Nifi cannot say that the code it is decoding from the Base64 field that is coming from Oracle. Sorry for the lack of knowledge on the subject.       ExecuteSQL   UpdateAttribute   Base64EncodeContent   PutEmail    PutEmail    ... View more

We can't use PutEmail processor direct for attachment. We can use FetchFile processor and direct to PutEmail processor to send attachment, but it fetchFile will send the attachment for the first trigger only.   Alternatively for send attachment, you can use ExecuteScript Processor using python module and pass the argument parameter of mailto and fromto to script.   import smtplib from email.mime.base import MIMEBase from email.mime.multipart import MIMEMultipart from email.mime.text import MIMEText from email import encoders fromaddr = 'SENDER@EMAIL.COM' #$arg1 Argument from NIFI Flow toaddr = 'RECIPIENT@EMAIL.COM' #$arg2 Argument from NIFI Flow msg = MIMEMultipart() msg['From'] = fromaddr msg['To'] = toaddr msg['Subject'] = 'Define the Subject' body = 'Define Body' msg.attach(MIMEText(body)) files = ['/user/path/filename1', '/user/path/filename2'] for filename in files: attachment = open(filename, 'rb') part = MIMEBase("application", "octet-stream") part.set_payload(attachment.read()) encoders.encode_base64(part) part.add_header("Content-Disposition", f"attachment; filename= {filename}") msg.attach(part) msg = msg.as_string() try: server = smtplib.SMTP('smtp.email.com:21') server.ehlo() server.starttls() server.login(fromaddr, 'user') server.sendmail(fromaddr, toaddr, msg) server.quit()     @leandrolinof wrote: @Aaki_08 good morning.   I have a situation where I need to email buyers of a certain ID with a certain PDF attachment. This attachment will be saved in a field in a table in oracle. Today I'm already using PutEmail to send the E-mail, but I don't know how to send the attachment. Could you help me, please?     @leandrolinof wrote: @Aaki_08 good morning.   I have a situation where I need to email buyers of a certain ID with a certain PDF attachment. This attachment will be saved in a field in a table in oracle. Today I'm already using PutEmail to send the E-mail, but I don't know how to send the attachment. Could you help me, please?       ... View more

@steven-matison  thank you so much. ... View more

@MattWho @pvillard @Shu_ashu @Dubeyji @VidyaSargur @TimothySpann can You help me? ... View more

@MattWho,   Good afternoon.   I changed my flow to make a counter by the processor "RouteOnAttribute 1.12.1" so every time I have a record to be sent to the API and have a return to store in Oracle, I do the LOOP through RouteOnAttribut. Thus sending one FlowFile at a time to the PROCEDURE call in Oracle by "ExecuteSQL 1.12.1"   But what is happening at the moment is that from the second time it goes through the LOOP, it seems to me that the Flow to get the attributes "CODIGO" and "JSON_ORIGINAL" is not passing the values ​​that I requested in the processor "EvaluateJsonPath 1.12.1" passing the parameters as null.   Do you have any idea what may be happening in this second flow passage within the LOOP?     This is the JSON ORIGINAL of the second stream that I must send to Oracle =  This is OK with the CODE attribute as you can check.   This is Split Configure Processor =     This is EvaluateJsonPath 1.12.1 Configure Processor =   This is MergeContent 1.12.1 Configure Processor =     This is ExecuteSQL 1.12.1 Configure Processor =   ... View more

@MattWho    Thanks for the time available for my problem, the "ExtractText" worked perfectly for my case and the data was saved in my database.   Grateful. ... View more