InsertDE

InsertDE

This function inserts a row in a Data Extension with the specified column name and value pairs. No output is returned from this function.

Arguments

InsertDE(1,2,3,[4a,4b]...)

NOTE: Additional pairs of columns and values can be appended as arguments.

NOTE: This function only works in an email. Use InsertData if you need to insert rows into a Data Extension in a landing page, microsite page or CloudPage, or in an SMS message.

NOTE: According to the official order of processing, insert operations for the entire send are processed at the completion of the send. If your scripting utilizes a RaiseError function that aborts an entire send, the insert operation will not be completed.

Example 1

The following illustrates the use of this function with the minimum number of arguments.

Data Extension: LoyaltyMembers

The LoyaltyMembers Data Extension includes these rows:

Here is an example utilizing the preceding context:

%%[

var @emailAddress, @subscriberKey

set @emailAddress = "barb@limedash.com"
set @subscriberKey = "5767"

InsertDE("LoyaltyMembers","EmailAddress", @emailAddress,"SubscriberKey", @subscriberKey)

]%%

After the operation, the LoyaltyMembers Data Extension includes these rows:

Example 2