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
You need to set a value for your lookup.
set @lookupvariable = LookUp('sub_id_reference_prod','subscriberid','email_address',@email_address)