{"id":31456,"date":"2018-04-21T15:47:47","date_gmt":"2018-04-21T15:47:47","guid":{"rendered":"https:\/\/ampscript.guide\/insertdata\/"},"modified":"2021-04-06T01:18:28","modified_gmt":"2021-04-06T01:18:28","slug":"insertdata","status":"publish","type":"post","link":"https:\/\/ampscript.guide\/insertdata\/","title":{"rendered":"InsertData"},"content":{"rendered":"

InsertData<\/h2>\n

This function inserts a row in a Data Extension with the specified column name and value pairs. It returns the number of rows inserted by the operation.<\/p>\n

Arguments<\/h3>\n

InsertData(1,2,3,[4a,4b]...)<\/code><\/p>\n\n\n\n\n\n\n\n\n\n
Ordinal<\/th>\nType<\/th>\nRequired<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
1<\/td>\nString<\/td>\nTrue<\/td>\nName of the Data Extension receiving the new row<\/td>\n<\/tr>\n
2<\/td>\nString<\/td>\nTrue<\/td>\nName of the column receiving the value<\/td>\n<\/tr>\n
3<\/td>\nString<\/td>\nTrue<\/td>\nValue to insert into the column<\/td>\n<\/tr>\n
4a<\/td>\nString<\/td>\nFalse<\/td>\nAdditional column name receiving the value (see note)<\/td>\n<\/tr>\n
4b<\/td>\nString<\/td>\nFalse<\/td>\nAdditional value to insert into the column (see note)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n

NOTE: Additional pairs of columns and values can be appended as arguments.<\/p>\n

NOTE: This function only works in a landing page, microsite page or CloudPage, or in an SMS message in MobileConnect. Use the InsertDE<\/a> function if you need to insert rows into a Data Extension in an email.<\/p>\n<\/blockquote>\n

Example 1<\/h3>\n

The following illustrates the use of this function with the minimum number of arguments.<\/p>\n

Data Extension<\/strong>: LoyaltyMembers<\/em><\/p>\n\n\n\n\n\n\n\n\n\n
Name<\/th>\nData Type<\/th>\nLength<\/th>\nPrimary Key<\/th>\nNullable<\/th>\nDefault Value<\/th>\n<\/tr>\n<\/thead>\n
EmailAddress<\/td>\nEmailAddress<\/td>\n254<\/td>\nN<\/td>\nN<\/td>\n<\/td>\n<\/tr>\n
SubscriberKey<\/td>\nText<\/td>\n254<\/td>\nY<\/td>\nN<\/td>\n<\/td>\n<\/tr>\n
FirstName<\/td>\nText<\/td>\n50<\/td>\nN<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
LastName<\/td>\nText<\/td>\n50<\/td>\nN<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
Created<\/td>\nDate<\/td>\n<\/td>\nN<\/td>\nY<\/td>\nCurrent Date<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

The LoyaltyMembers<\/em> Data Extension includes these rows:<\/p>\n\n\n\n\n\n\n\n
EmailAddress<\/th>\nSubscriberKey<\/th>\nFirstName<\/th>\nLastName<\/th>\nCreated<\/th>\n<\/tr>\n<\/thead>\n
doug@limedash.com<\/td>\n8473<\/td>\nDoug<\/td>\nSmith<\/td>\n2017-10-21 12:01<\/td>\n<\/tr>\n
suzy@limedash.com<\/td>\n5497<\/td>\nSuzy<\/td>\nJackson<\/td>\n2017-10-20 11:01<\/td>\n<\/tr>\n
dale@limedash.com<\/td>\n7114<\/td>\nDale<\/td>\nCameron<\/td>\n2017-10-19 10:01<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Here is an example utilizing the preceding context:<\/p>\n

%%[\n\nvar @insertCount, @emailAddress, @subscriberKey\n\nset @emailAddress = \"barb@limedash.com\"\nset @subscriberKey = \"5767\"\n\nset @insertCount = insertData(\"LoyaltyMembers\",\"EmailAddress\", @emailAddress,\"SubscriberKey\", @subscriberKey)\n\n]%%\ninsertCount: %%=v(@insertCount)=%%<\/code><\/pre>\n
Output<\/h4>\n
insertCount: 1<\/code><\/pre>\n
After the operation, the LoyaltyMembers<\/em> Data Extension includes these rows:<\/p>\n\n\n\n\n\n\n\n\n
EmailAddress<\/th>\nSubscriberKey<\/th>\nFirstName<\/th>\nLastName<\/th>\nCreated<\/th>\n<\/tr>\n<\/thead>\n
doug@limedash.com<\/td>\n8473<\/td>\nDoug<\/td>\nSmith<\/td>\n2017-10-21 12:01<\/td>\n<\/tr>\n
suzy@limedash.com<\/td>\n5497<\/td>\nSuzy<\/td>\nJackson<\/td>\n2017-10-20 11:01<\/td>\n<\/tr>\n
dale@limedash.com<\/td>\n7114<\/td>\nDale<\/td>\nCameron<\/td>\n2017-10-19 10:01<\/td>\n<\/tr>\n
barb@limedash.com<\/td>\n5767<\/td>\n<\/td>\n<\/td>\n2017-10-22 13:01<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
Example 2<\/h3>\n
\n\n\n\t\n\t
\n\n\t\t\n\t\t