How to get the data in a csv file while an email copy sent to customer
Hi @vindra ,
Accessing delivery content via the BCC Archiving option is an effective solution, though I understand it may be somewhat slow.
As an alternative, you might consider using the GetMirrorURL function in Adobe Campaign. This function allows you to retrieve the mirror URLs of each delivery, containing the exact content that each recipient received. By leveraging HttpClientRequest, you can then access this content, extract the HTML portion, and store it in a CSV file.
Below is an example of a function you could experiment with. If it meets your requirements, it will allow you to obtain the HTML content of the emails, which you can then extract, save to a CSV file, and transfer to your SFTP or data warehouse for further access.
var mirrorUrl = nms.delivery.GetMirrorURL(deliveryId, "messageId");
var httpClient = new HttpClientRequest(mirrorUrl);
var response = httpClient.execute();
var htmlContent = response.getBodyAsString();
However, if this solution proves to be less efficient, more tedious, or not significantly faster, then using BCC Archiving should be the preferred approach.
Best regards,
MEIT MEDIA (https://www.meitmedia.com)
Contact Us: infomeitmedia@gmail.com
Related Conversations
