UpsertDE

Updates or inserts information into a data extension as indicated by the array containing the listed column name and value pairs. This method adds the information if the data extension does not contain an applicable value or updates the existing applicable value to the new value. You can include multiple column name and value parts in a single call. You can use this method in sendable contexts, such as email messages.

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

OrdinalTypeDescription
1stringRequired. Name of data extension
2arrayRequired. Array containing column names to filter on
3arrayRequired. Array containing values to filter on
4arrayRequired. Array containing column names to include updates
5arrayRequired. Array containing column values to update