I have an odd bug that I am running into. I will try to explain what we are seeing as best as possible without writing a novel! What we are trying to do is run a bit of AMPscript to add/update a record to a data extension within our instance. When we use the InsertDE function, the subscriber id writes to the mentioned table below (sub_id_reference_prod). This function works fine at time of send.
I then used the @sub_id_update value to make sure something was available to populate if we were to use the upsertde function. This too worked.
Now when I add these components together with the UpsertDe function, the Upsert call does not add subscriber id to the referenced table.
I have tried multiple variations and nothing adds the subscriber id using the upsert function. Is there a limitation with the UpsertDe function that doesn't allow a subscriber id update?
set @subscriberid = subscriberid
set @email_address = emailaddr
set @value = 'true'
set @subkey = SubscriberKey
InsertDE('sub_id_reference_prod','email_address',@email_address, 'subscriberid',@subscriberid)
set @sub_id_count = LookUpRows('sub_id_reference_prod','email_address',@email_address)
if rowcount(@sub_id_count) > 0 then
set @sub_id_update =
LookUp('sub_id_reference_prod','subscriberid','email_address',@email_address)
UpsertDE('ent.mbusa_contact_master_de',1,'subscriber_key',@subscriberkey,'email_address',@email_address,'subscriberid',@sub_id_update)
endif
set @sub_id_update =from the following Lookup() statement. I find that new lines inside of AMPScript variable setting can cause some odd behaviors at times.