5. Data Extension Based Scenario - Richard98PL/SFMC-Profile-Subscription-Center GitHub Wiki

Data Extension Columns Retrieve

var dataRows = Platform.Function.LookupOrderedRows("dataExtensionName",1,"Email desc","Email",email);
var id = dataRows[0]["Id"];
var firstName = dataRows[0]["FirstName"];
var lastName = dataRows[0]["LastName"];
var email = dataRows[0]["Email"];
var preference1 = dataRows[0]["Preference1"];

Data Extension Columns Update

var dataRows = Platform.Function.LookupOrderedRows("dataExtensionName",1,"Email desc","Email",email);
var id = dataRows[0]["Id"];
var fields = ["FirstName","LastName","Email","Preference1"];
var values = [firstName,lastName,email];

var result =  Platform.Function.UpdateData("dataExtensionName",["Id"],[id],fields,values);