Platform.Function.UpdateData()

Updates data in a data extension and returns the number of rows updated.

You can use this function in CloudPages, landing pages, microsites, and SMS messages in MobileConnect. To update rows in a data extension in an email, use the Platform.Function.UpdateDE() function.

Syntax

Platform.Function.UpdateData(1, 2, 3, 4, 5)

Properties

Usage

To use the function, first pass it the name of the data extension that contains the data you want to update. Next, pass it an array of the columns to search to find the row that you want to update and optionally an array that includes the values that identify the row to update. Finally, pass it an array that contains the names of the columns that you want to update the data in, and an array that contains the updated values for those columns.

Updating a Single Value

In this example, a data extension called "Flights" contains the data in this table.

To update the Price value for FlightId 10, use this function.

<script runat="server">
  Platform.Load("core", "1");
  try {
    var result = Platform.Function.UpdateData("Flights",
                                              ["FlightId"],
                                              [10],
                                              ["Price"],
                                              ["316"]);
    Write(Stringify(result));
  } catch(e) {
    Write(Stringify(e));
  };
</script>

The function returns 1, indicating that it updated one row. The data extension now contains this data.

Updating Multiple Values in One Row

You can use the Platform.Function.UpdateData() function to update more than one column in a single row in one operation. To update multiple columns, you must provide one set of search criteria for each column that you want to update.

This example uses a data extension called "Flights2" that contains the data in this table.

Use this code to update the Dest, Price, and PerBagSurcharge fields for FlightId 1.

<script runat="server">
  Platform.Load("core", "1");
  try {
    var result = Platform.Function.UpdateData("Flights2",
                                              ["FlightId","Origin","Dest"],
                                              [1, "IND", "NYC"],
                                              ["Dest", "Price", "PerBagSurcharge"],
                                              ["JFK", 75, 10]);
    Write(Stringify(result));
  } catch(e) {
    Write(Stringify(e));
  };
</script>

The function returns 1, indicating that it updated one row. The data extension now contains this data.