[SalesForce] Trying to update fields in Data Extension with SSJS

I realize this might a very basic question but I am completely new to SSJS so thanks for the understanding.

In Marketing Cloud I am trying run SSJS script in order to update a field in a data extension. Using the available documentation I have put together the following:

<script runat=server language="JavaScript" executioncontexttype="Post" executioncontextname=test>

var TestDE = DataExtension.Init("TEST_DataExtension");
TestDE.Rows.Update({"AccountId":"Test_account"}, ["ContactId"],
["0032405071zljdyAAA"]);

</script>

The syntax seems to be correct and I can run the query via automation studio with no errors but the data extension is not getting updated the way I want it. In other words, field AccountId in TEST_DataExtension is not being changed to "Test_Account" for user with ContactId of 0032405071zljdyAAA.

Any idea why this might be?

Best Answer

Declaration of Server-Side JavaScript Block is incorrect and you have not included the SSJS libraries in your SSJS code.

<script runat=server language="JavaScript" executioncontexttype="get">
Platform.Load("Core","1.1");

var TestDE = DataExtension.Init("TEST_DataExtension");
var result = TestDE.Rows.Update({"AccountId":"Test_account"}, ["ContactId"],["0032405071zljdyAAA"]);

Write('<b>Output:</b>'+result);
</script>

Output: 1

Related Solutions

[SalesForce] Update Data Extension via WSProxy

I'd put a try/catch around the whole thing and see what you get. You're also missing the runat attribute on your script tag.

<script runat="server">
Platform.Load("Core","1");

try {

    var api = new Script.Util.WSProxy();
    var target = Variable.GetValue("@target");
    var type = Variable.GetValue("@type");
    var qdef = Variable.GetValue("@definition");

    /*Build DE Object*/
    var updateObject = {
    CustomerKey: 'QueryLog',
    Properties: [
        {
            Name: 'Target'
            Value: target
        },
        {
            Name: 'Type'
            Value: type
        },
        {
            Name: 'QueryDef'
            Value: definition
        },
        {
            Name: 'RunDate'
            Value: Platform.Function.Now()
        }
    ]
    };

    var options = {SaveOptions:[{'PropertyName':'*',SaveAction:'UpdateAdd'}]};
    var res = api.updateItem('DataExtensionObject',updateObject,options);

} catch (e) {
    Write("<br>e: " + Stringify(e));
}
</script>

[SalesForce] SFMC – SSJS Bulk update to All Subscribers list

First of all: Welcome to Salesforce StackExchange! I'm afraid there is no standard code to post that works for everyone and details of your instance and data structure are needed. Stack exchange is meant to ask specific questions for example on problems in code you've written.

For the basic structures and syntax SSJS is just regular JavaScript. So if you like to learn how to do this, I'd suggest reading some JavaScript Tutorials as there are countless excellent ones that you can easily find on the internet.

Here you can find an article regarding Loops: MDN - Looping code

To have your data extension as "source" you need to query it using SSJS. Information can be found in the Salesforce documentation: Data Extension Retrieve.

An easier and more performant approach would be extracting the changed records and then importing them to Marketing Cloud. This can also be done completely inside Automation Studio. I don't know your exact use case, but it will most certainly include the following steps:

SQL Query activity
Data Extract Activity
File Transfer Activity
Import File Activity

A documented example, that compares a (synchronized) data extension with the all subscribers list and updates it, be found here: How to sync email address changes from Sales/Service Cloud to All Subscribers list in Salesforce Marketing Cloud?

Best Answer

Related Solutions

[SalesForce] Update Data Extension via WSProxy

[SalesForce] SFMC – SSJS Bulk update to All Subscribers list

Related Topic