UpsertData

Overview

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 non-sendable contexts, such as landing pages. This call returns the number of rows modified.

Syntax

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

Function Properties

OrdinalTypeDescription
1stringRequiredName of data extension
2arrayRequiredArray containing column names to filter on
3arrayArray containing values to filter on
4arrayRequiredArray containing column names to include updates
5arrayRequiredArray containing column values to update

Examples