Sign in to Community
Sign in to view all badges
I'm trying to create a recipient delivery report in Adobe Campaign showing all the deliveries a recipient received over time.
In addition I want to add by each of the deliveries the link to the mirror page of this recipient.
The 'XXX...' part is the different part for each recipient/delivery
I've looked in the documentation and also in this forum, and saw a similar issue (https://forums.adobe.com/message/9792714#9792714)
but still couldn't figure out how to do it.
According to the answer there I can use the 'GetMirrorURL' method but I'm not sure what parameters I should give to this function.
Looking in the jaspi help I saw it gets 'eventHistoId' from schema nms:eventHisto.
This table is empty on my system, and I'm not sure how it is related.
Also tried running this method with different parameters like broadlogID but I get an error saying 'Error while compiling script - GetMirrorUrl is not defined.'
Can someone please help me understand how to handle this method or is there a different way of getting the URL
Adobe Campaign Version 6.1.1 build 8754
Server version 6.1.1 build 8754
It was helpful! I am getting this error though:
11/21/2017 4:37:20 PM Error while executing the method 'GetMirrorURL' of service 'nms:delivery'.
11/21/2017 4:37:20 PM Cannot load document of type 'Deliveries (nms:delivery)' satisfying condition '(@id = 332656168) AND ((@deleteStatus = 0))'.
11/21/2017 4:37:20 PM The requested database record does not exist.
11/21/2017 4:37:20 PM AND ((D0.iDeleteStatus = :2))' could not be executed. Param(0)=332656168 Param(1)=0
11/21/2017 4:37:20 PM SQL statement 'SELECT D0.iMappingId, D0.iDeliveryMode, D0.iMidRemoteId, E1.sMirrorURL, E1.sAccount, E1.sPassword, E1.sServer, D0.mData FROM NmsDelivery D0 JOIN NmsExtAccount E1 ON (E1.iExtAccountId = D0.iDeliveryProviderId) WHERE (D0.iDeliveryId = :1)