Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

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

karanv22355550
Level 2
Level 2

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?

1 Accepted Solution
Darren_Bowers
Correct answer by
Community Advisor
Community Advisor
2 Replies
Milan_Vucetic
Community Advisor
Community Advisor

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
Level 2
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
Correct answer by
Community Advisor
Community Advisor