Skip to content

Instantly share code, notes, and snippets.

@wvpv
Last active May 4, 2023 10:01
Show Gist options
  • Star 7 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • Save wvpv/6ce56f611b29dcc80bfc5c401ff7e316 to your computer and use it in GitHub Desktop.
Save wvpv/6ce56f611b29dcc80bfc5c401ff7e316 to your computer and use it in GitHub Desktop.
Update Salesforce Objects with Server-Side JavaScript
<script type="text/javascript" runat="server">
Platform.Load("core", "1");
var debug = 1;
// detect form submission
if (Request.Method == "POST") {
// retrieve the input values from the form payload
var subscriberKey = Request.GetFormField("subscriberKey");
var email = Request.GetFormField("email");
var firstName = Request.GetFormField("firstName");
var lastName = Request.GetFormField("lastName");
// ensure the subscriberKey has a value
if (!isEmpty(subscriberKey)) {
try {
// update the SF object indicated by the subscriberKey
var updateSFResults = updateSF(subscriberKey,0,email,firstName,lastName);
if (debug) {
Write("<br>updateSFResults: " + updateSFResults);
}
} catch (e1) {
if (debug) {
Write("<br>e1: " + Stringify(e1));
}
} // of catch
} // of sk check
} // of post
function isEmpty(str) {
return (!str || 0 === str.length);
}
function updateSF(subscriberKey, HasOptedOutOfEmail, Email, FirstName, LastName) {
var results = 0;
var SFIDPattern = new RegExp("^[a-zA-Z0-9]{18}");
if (SFIDPattern.test(subscriberKey) == true) {
var fieldArr = [];
fieldArr.push('HasOptedOutOfEmail');
fieldArr.push(HasOptedOutOfEmail);
fieldArr.push('Email');
fieldArr.push(Email);
if (!isEmpty(FirstName)) {
fieldArr.push('FirstName');
fieldArr.push(FirstName);
}
if (!isEmpty(LastName)) {
fieldArr.push('LastName');
fieldArr.push(LastName);
}
// detect Contact or Lead
var sfObj = subscriberKey.substring(0,3) == "003" ? "Contact" : "Lead";
var updateSFObject = "";
updateSFObject += "\%\%[ ";
updateSFObject += "set @SFUpdateResults = UpdateSingleSalesforceObject('" + sfObj + "',";
updateSFObject += "'" + subscriberKey + "','"+ fieldArr.join("','") + "'";
updateSFObject += ") ";
updateSFObject += "output(concat(@SFUpdateResults)) ";
updateSFObject += "]\%\%";
try {
results = Platform.Function.TreatAsContent(updateSFObject);
} catch (e2) {
if (debug) {
Write("<br>e2: " + Stringify(e2));
}
}
}
return results
}
</script>
<!-- YOUR HTML AND FORM GOES HERE -->
@wvpv
Copy link
Author

wvpv commented May 27, 2020

Line number 69 should be
var sfObj = subscriberKey.substring(0, 3) == "003" ? "Contact" : "Lead";

Updated. Thank you!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment