Overview

This set of functions provides a means of interacting with rows in Data Extensions. Applications include:

  • retrieving specific column values with simple criteria
  • retrieving row sets with simple criteria
  • executing predefined filters on data extension rows
  • adding data extension rows
  • updating column values in data extension rows
  • retrieving row counts.

AMPscript functions that retrieve, update and delete rows in Data Extensions share a common characteristic: they can accept one or more column name/value pairs as parameters.

NOTE: Not all of the Data Extension functions can be used in the context of an email. A few are only intended for landing pages, microsite pages or CloudPages, while others are only for use in SMS messages.

TIP: If you are in a child business unit and are interacting with a Data Extension in the Shared Data Extension folder, you must reference the Data Extension name with a ENT. prefix (for example, ENT.DataExtensionName).

NOTE: All Data Extensions have a hidden identity column called _CustomObjectKey. It’s unique for each row in the Data Extension.