Data Extension Functions

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...

ContentArea

ContentArea This function returns the content stored in the specified Content Area and optionally wraps the content in an Impression Region. Arguments ContentArea(1,2,3,4,5) Ordinal Type Required Description 1 Number True The ID of the Content Area to return. This can...

ClaimRow

ClaimRow This function returns a single row from a Data Extension and reserves the values to prevent them from being used by another operation. If a row is found and is unclaimed, the designated claimed column is set to true and data from that row is returned. If a...

ContentAreaByName

ContentAreaByName This function returns the content stored in the specified Content Area and optionally wraps the content in an Impression Region. Arguments ContentAreaByName(1,2,3,4,5) Ordinal Type Required Description 1 String True The full path of the Content Area...

ClaimRowValue

ClaimRowValue Like the ClaimRow function, ClaimRowValue returns a single row from a Data Extension and reserves the values to prevent them from being used by another operation. If a row is found and is unclaimed, the designated claimed column is set to true and data...

InvokeExecute

InvokeExecute This function executes the instantiated Marketing Cloud API Object. It returns a RequestID value (because it is executed asynchronously), an API Object containing a status message and an error code value. Arguments InvokeExecute(1,2,3) Ordinal Type...