Generating and exporting HTML (including variables fr...

[marcelfries]

Hello everyone,

your help would be much appreciated to achieve the following requirements:

- In the end we would like to generate HTML files (one per recipient) and export them to a SFTP server. The HTML files shall be generated based upon a certain delivery template, but should include the recipient's individual information (variables from the workflow / targetData).

- No email/delivery shall be sent, so we cannot use the MirrorPage function.

We already thought about "fake" sending the emails to our own email inbox, to have Adobe generate all the MirrorPages. But it seems unnecessary and a overkill to have 100k emails be sent every day, without the actual need of sending them.

Can you think of another way to achieve this (100k individual HTML files generated and exported to SFTP, including workflow data for personalization)?

Your help would be much appreciated!  

Kind regards

Marcel

[DavidKangni]

Hi Marcel,

Your case looks like an email archiving case. Please check Email BCC

Thanks,

David

[marcelfries]

Hi David,

thanks for your answer. You are right, it looks like that.

Our issue with the Email BCC/Archive option is, that we don't want the emails to be sent to the recipients - we just want the "MirrorPage" view. We want to link to it from the user's account. 

The setup all in all is a bit more complex, so we cannot really rely on sending the emails and then accessing the mirror page or archiving the emails during sendout.

If anyone has another approach/solution, that would be much appreciated  

Kind regards, Marcel

[psheppar · Accepted solution]

1. Design you query

2. Add a javascript node to the end

3. Create a loop in javascript to process the targetData in batches of say 1k, using queryDef method

4. Script your content and write it to the local SFTP folder via javascript File object

https://docs.adobe.com/content/help/en/campaign-classic/technicalresources/api/f-saveFile.html