Binary pdf corrupted in email attachment

[NicoSQ]

I get a .pdf file in a base64 string from a web hook:

Using the SendGrid module, I’m trying to send an email and attaching this file as an attachment.

• I’ve tried attaching the base64 I receive as is and I get a corrupted .pdf on in the email.

• I’ve tried using the ‘toBinary(;base64)’ function within the email attachment field and I get a .txt file full of random characters in the email.
  

Any other alternatives or explanations as to why I can’t get the .pdf out the other end?
Thanks!

[Bjorn.drivn]

@NicoSQ The binary data you get is containing the encoding parameter as well. You will have to remove the data:application/pdf;base64, part so it only leaves you with the actual binary data.
Use something like the replace() function for example to do this.
Let me know how that goes.

[NicoSQ]

Thanks Bjorn.

Any recommendation on a smart way to do this when the encoding is dynamic? Depending on the file type, this will change.

How can I say "remove everything to the left of the first ‘comma’ "?
Appreciate the help!

[Bjorn.drivn]

@NicoSQ You can use RegEx:

{{replace("data:application/pdf;base64,s87shdfui32nuiwehf8ef"; "/.+base64\,/"; emptystring)}}

In this case replace the static base64 text with the variable you have.

See more about it here:

How to use Regex in Make?

Last updated: 2024/14/01 In regular cases it’s very usefull to use Regex (or Regular Expressions) if you want to extract or replace data in some text. When there always is a similar pattern in your text data, regex is ideal to use. But how can you use regex? Table of content 1 – What is regex 2 – How to begin with RegEx 3 – Starting development 4 – Basics - Extracting data from text 5 – Basics - Replacing data with the replace() function 6 – Basics - Named capturing groups 7 – Advanced -…

[NicoSQ]

Thanks Bjorn, the regex worked as expected!

Nonetheless, I now get a .txt file with the entire binary in it:

How can I get this to be the .pdf I’m being sent?

Appreciate the help!

[Bjorn.drivn]

Take a look here @NicoSQ , see if that helps you:

How to convert base64 string to binary-file and store on sftp

Hey to all you Makers, So I ask my self how to convert base64 string to binary-file and store on sftp. [Bildschirm­foto 2022-12-20 um 11.20.06] I tried it like so. But for some reason the image finally is broken so you can not open. What ist the problem? Thanks for you support Cahore

[NicoSQ]

I solved this by adding a ‘.pdf’ at the end of the file name!