Updates an existing row in a data extension for the specified number of filter columns listed in name value pairs followed by a list of columns to be updated in name and value pairs. If no data exists in that row, the function inserts a row. The function returns the number of affected rows. You can include multiple name and value pairs to build your WHERE and INSERT clauses. Use this function with landing pages and SMS messages only.


UpsertData(1, 2, 3, 4, 5, 6)

Function Properties

1stringRequiredName of data extension from which to update the specified row
2numericRequiredNumber of columns used to build WHERE clause
3stringRequiredColumn name to build WHERE clause
4stringRequiredValue used to build WHERE clause
5stringRequiredColumn name to build INSERT clause
6stringRequiredValue used to build INSERT clause