I'm having an issue where I'm unable to retrieve any rows from a DE that I know is populated inside an automation.
Here is my code:
<script runat="server">
Platform.Load("core","1");
var stagingDE = DataExtension.Init('Third_Party_Email_Acquisition_Stagingv2');
var filter = {Property:"Processed",SimpleOperator:"equals",Value:"FALSE"};
var data = stagingDE.Rows.Retrieve(filter);
var end = data.length;
for (var i = 0; i < end; i++)
{
var emailAddress = data[i]['Email'];
var brand = data[i]['Brand']
var newEmailAddress = emailAddress.replace("+", "%2B");
var emailAcqStaging = ent.Third_Party_Email_Acquisition_Staging.replace(".", "%2E");
var executeURL = 'http://pub.s7.exacttarget.com/5z43cwwr0wy?DE=Third_Party_Email_Acquisition_Stagingv2'+ '&E=' + newEmailAddress + '&B=' + brand;
var response = HTTP.Get(executeURL);
}
</script>
I've tested running the HTTP.Get seperatly and know it's working just fine when I hardcoded the url in. If I remove the for loop and just try to parse the first variable in the array, data[0] the script throws errors.
I have also tried removing the filter and just calling Rows.Retrieve, same result as before.
If anyone can help with this that would be great.