How to get the data in a csv file while an email copy sent to customer

[vindra]

Hi

How to get the data in a csv file while an email copy sent to customer, its like BCC but the BCC search was not very quick to find a emails as we send 100k emails some times more. In this  case how to find a copy of email copy stored? for better quick search.

[ShashankNigam02]

Can you please elaborate the use case?

[MeitMedia]

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)

Find us on LinkedIn

Contact Us: infomeitmedia@gmail.com