InsertDE
Inserts rows into a data extension. This function doesn’t return any output.
You can use this function to insert data into a data extension from emails. Use the InsertData() function to insert data from CloudPages, landing pages, microsites, and SMS messages in MobileConnect.
The InsertDE()
function has three parameters.
dataExt
(string): Required. The name of the data extension that you want to insert a row into.columnNames[]
(array): Required. An array that contains the names of the columns to populate with data in the new row.values[]
(array): Required. An array that contains the values to insert into the columns specified in thecolumnNames
array.
To insert data into a data extension, specify the data extension that you want to insert a row into. Next, specify the columns that you want to populate with data in the new row. Finally, specify the values for those columns. Make sure that the values in the second array align with the columns in the first array.