UpsertData
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)
Ordinal | Type | Description | |
---|---|---|---|
1 | string | Required | Name of data extension from which to update the specified row |
2 | numeric | Required | Number of columns used to build WHERE clause |
3 | string | Required | Column name to build WHERE clause |
4 | string | Required | Value used to build WHERE clause |
5 | string | Required | Column name to build INSERT clause |
6 | string | Required | Value used to build INSERT clause |