Build email extracting a pdf from SFTP

[RaulOcana]

Hi guys,

I have to send several emails to our customers, each email has it's own database (csv file from SFTP) and it's own attachment (pdf from SFTP).

I know how to automatically extract the CSV file to prepare the segmentation and send the emails on a workflow, but is there a way to extract the PDF from the SFTP and attach it to the html before sending it automatically?

Thanks!

Regards,

Raúl

[ovot · Accepted solution]

@RaulOcana , 
If you know how to process the .csv then it should be similar for the .pdf files.
Then you could use a script in your delivery activity, inside the workflow, to attach the file, like this:

var filename = "file.pdf";
delivery.attachment.add(
  <attachment compressMode="print" filterActive="false" label="{filename}"
              nameScriptActive="false" type="normal" upload="false">
    <name>{filename}</name>
  </attachment>)
}

delivery.hasAttachments = true