I want to pull in the view as webpage url from the Sendlog, but it looks like my lookup does not return any results. This is a code snippet from my email:
var @vawp, @subID, @jobID, @batchID set @subID = AttributeValue("subscriberid") set @jobID = AttributeValue("jobid") set @batchID = AttributeValue("_JobSubscriberBatchID") set @vawp = LookUp('SENDLOG_DE', 'view_email_url', 'SubID', @subID, 'JobID', @jobID)
When I do a LookupRows() on this SendlogDE, it does return rows. There is data in my sendlogDE, with correct subscriberdID and jobID.
Even when I do LookupRows() -> Row() --> Field() , it does not return a value.
This is my html
<a href="%%=RedirectTo(@vawp)=%%" alias="VAWP" target="_blank">View email in browser</a>
And I get the following error when I click the link (ofcourse the link is probably empty but gets url-proofpointed).
We cannot direct you to the requested web page at this time. Please try again.
I want to get the vawp url from the sendlog, because the journey builder campaign overwrites the sendable DE every day using a sql query. This is why the out of the box vawp url doesn't work. According to documentation, I should be able to get the url from the sendlog, but the lookup doesn't return data. The URL in the sendlog is the one I need because this url does not break.
Is there something that I'm missing?