When adding the AMPSCRIPT "InsetData" function in my Cloud Page, it get an error 500

Question

I'm having problems on an unsubscribe page when i add an insertDATA function. The page is working well without this function.

SO i try to insert "SubscriberID" (Data type is texte 50 length, and it's the Primary key) and "rm_optin_c" = false (data type is Boolean, nullable is true and default value is "false") into the DE "DE_TAMPON_Unsub_Pref_Page".

The code that makes the Cloudpage error is this one :

Set @optintampon = 'false'
set @insertoptin = insertData("DE_TAMPON_Unsub_Pref_Page", "rm_optin_c", @optintampon, "SubscriberID", @subkey)

The AMP for the entire Cloudpage is

  set @subkey = _subscriberKey
  set @email = AttributeValue("emailaddr")
  set @brandnlspecialoccasion = IIF(RequestParameter("brandnlspecialoccasion")=='on','true','false')
  set @cocktailinspiration = IIF(RequestParameter("cocktailinspiration")=='on','true','false')
  set @distillerynews = IIF(RequestParameter("distillerynews")=='on','true','false')
 
 
 
 
 
  IF (@brandnlspecialoccasion == 'false' AND @cocktailinspiration == 'false' and @distillerynews == 'false') then
  set @version = 'A'
  
  

  
    set @updateRecord = UpdateSingleSalesforceObject(
                             "Contact", @subkey,
                             "Newsletter_subscription_Brand_News_Sp__c", @brandnlspecialoccasion,
                             "NewsletterSubscriptionCocktailInspirat__c", @cocktailinspiration,
                             "Newsletter_subscription_Dystillerie__c", @distillerynews,
                             "rm_OptIn__c","false"
                        );
 
 Set @optintampon = 'false'

set @insertoptin = insertData("DE_TAMPON_Unsub_Pref_Page", "rm_optin_c", @optintampon, "SubscriberID", @subkey)


  else
  set @version = 'B'
   set @updateRecord = UpdateSingleSalesforceObject(
                             "Contact", @subkey,
                             "Newsletter_subscription_Brand_News_Sp__c", @brandnlspecialoccasion,
                             "NewsletterSubscriptionCocktailInspirat__c", @cocktailinspiration,
                             "Newsletter_subscription_Dystillerie__c", @distillerynews                          
                        );
  ENDIF
  
  
 IF RequestParameter("submitted") == true THEN
  set @optinglobal = IIF(RequestParameter("Email_Opt_in")=='on','true','false')
  IF @optinglobal == 'true' THEN
  set @updateRecord2 = UpdateSingleSalesforceObject(
                             "Contact", @subkey,                          
                             "rm_OptIn__c","true"
                        );
                        
                       ENDIF
                       ENDIF

 ]%%

Does anyone know why adding the insertData line makes the whole Page an error 500 ?

Answer 1

I suspect this is due to lack of proper data validation prior to firing your insertData() function. It expects a value in @subkey variable. This is set in this statement in the top of your code: set @subkey = _subscriberKey. However, when the Cloud Page is just viewed, and not accessed via CloudPagesUrl() function, _subscriberKey is not available, resulting in @subkey being set to null.

This means, that this CloudPage could theoretically work, when following a link from an email. To prevent the error from occurring, I would recommend you to check whether or not @subkey is actually set to something meaningful:

IF NOT EMPTY(@subkey) THEN
SET @insertoptin = insertData("DE_TAMPON_Unsub_Pref_Page", "rm_optin_c", @optintampon, "SubscriberID", @subkey)
ENDIF

A natural question would be:

But Lukas, I also use @subkey in my UpdateSingleSalesforceObject() function. Why doesn't this fail as well?

Well, UpdateSingleSalesforceObject() simply returns 0 if the update wasn't successful. While insertData() throws an error, in a very non-elegant way.