Read .txt file with HTML code for email body to send an email

Hello,

I am trying to configure an email sender snap which has reads the HTML code for the body of the email downstream. Currently, the HTML is in a .txt file in the groundplex, therefore I am using file reader to pick up the file but I do not know how to convert binary and then feed into the email sender snap.

Thank you very much for your help

@NickE

Once you read the .txt file, try with Binary to Document Snap, setting “encode or decode” to NONE.

The output from the binary to document snap will contain the content of the file(under the content field).

Regards,
Spiro Taleski

1 Like

Hi Spiro,

Thank you so much for you quick solution. That has successfully read the text file and outputting valid data. To read the code into the ‘Template body’ section of the email sender snap, I am using $ however it output email sender is ‘null’

Thanks so much again

Nick

1 Like

Would you use a mapper after the binary to document?

@NickE

The Binary to Document Snap apart from “content” field as an output gives additional details like “content-type” etc. You can directly get the “content” field in the Email Sender Snap(that will not cause any issues). But if you want to exclude any additional fields produced by Binary to Document Snap, then you can use mapper after binary to document, to map the necessary fields.

Regards,
Spiro Taleski

1 Like

Hi Spiro,

Thank you very much. I managed to get this working (there was an issue upsteam which wasn’t pulling through the targets on the mapper).
I have now encountered an issue that the output of the binary to document has replaced the tabs and newlines with \t and \n. I am trying to use the csv formatter and parser to recreate the data as it should be but I am stuck.
Many thanks

@NickE

Can you attach the sample data that you are getting as an output from Binary to Document Snap?

Regards,
Spiro Taleski

Hi Spiro,

Ah amazing, thank you very much.
Example is attached.
Thanks

Nick
Binary_to Document output0 (7).txt (1.8 KB)

@NickE

Try with replacing the newlines(\n) with <br> and tabs(\n) with &#9;

ex: $content.replaceAll ("\r\n","<br>").replaceAll ("\t","&#9;")

Regards,
Spiro Taleski

Thank you very much!