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

[karanv22355550]

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?

[Milan_Vucetic]

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]

Hey Milan!

[karanv22355550]

I tried this approach but its too slow. The function takes too long to run. It took me 2 minutes to run 1000 records. I have a million+ to get through.

[Darren_Bowers · Accepted solution]

@Jonathon_wodnickiposted up an alternate JS method here: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/generate-mirror-ur...

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