Basically I am using a CloudPage to update the customer event custom object in Salesforce CRM when a user clicks an ACTIVATE NOW button in the email.
The account is synched with CRM and I can retrieve other fields like FirstName, LastName and others so there is no integration issues. Also the custom field exists in CRM and I am using
Customer_Event__c to retrieve the value.
Also the purpose is to update the Custom object with the specified value passed to CRM. For example, there will be campaigns like ABC123 set within the CRM and the CloudPage will look for the same campaign to update a contact within the CRM with an Opt-In status.
I am receiving error message when I try to retrieve the Customer Event field but I am able to get other values like FirstName and LastName without any error.
Below is the code used to retrieve the Customer Event in CloudPages:
%%[ SET @SubscriberKey = QueryParameter('subkey') SET @LookUpCRM = RetrieveSalesforceObjects('Contact', 'Customer_Event__c', 'AccountId', '=', @SubscriberKey) IF RowCount(@LookUpCRM) > 0 THEN SET @CRMRow = Row(@LookUpCRM,1) SET @CustEvent = Field(@CRMRow, 'Customer_Event__c') ELSE SET @CustEvent = 'Null' ENDIF ]%%