Fast way to generate MirrorUrl for all emails sent in last 60 days in workflow. | Community
Skip to main content
karanv22355550
Level 2
April 15, 2020
Solved

Fast way to generate MirrorUrl for all emails sent in last 60 days in workflow.

  • April 15, 2020
  • 2 replies
  • 6888 views

Hello, I am currently working on generating Mirror Urls for all individuals who we sent an email to in the last 60 days. 

I am currently using a javascript icon in the workflow and using nms.delivery.GetMirrorURL(Delivery Id,Broadlog id) to loop through the temp table and add this to each row(each email sent). The problem is that it takes about 2 minutes to process 1000 rows so it is much to slow for a million records. 
I am currently try to use this code escapeUrl(cryptString(Delivery Id +'|' + BroadLog Id)) instead of GetMirrorUrl. The issue is I cant use nms.Delivery.escapeUrl(cryptString()). So how do I generate the whole mirror url with the escape(cryptString()) method?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Darren_Bowers

@jonathon_wodnickiposted up an alternate JS method here: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/generate-mirror-url-for-export/qaq-p/327420

Not sure if that will be any quicker, but worth a shot

2 replies

Milan_Vucetic
Level 9
April 16, 2020

Hi @karanv22355550 ,

 

you can use JS activity inside a workflow for example:

 

var url = nms.delivery.GetMirrorURL(000000001,"00000002")

 

000000001 is the delivery id

00000002  is the broadlogId (not the messageID) - passed as string in quotes

 

Regards,

Milan

karanv22355550
Level 2
April 16, 2020
Hey Milan!
Darren_Bowers
Darren_BowersAccepted solution
Level 9
April 16, 2020