Skip to content

Instantly share code, notes, and snippets.

@katydorjee

katydorjee/Delete a record from DataExtension using AMPscript.html

Last active September 20, 2023 01:26
Show Gist options
  • Save katydorjee/24fa882a02656619c869ea9bd0e005cc to your computer and use it in GitHub Desktop.
Save katydorjee/24fa882a02656619c869ea9bd0e005cc to your computer and use it in GitHub Desktop.
Download ZIP
Delete a record from DataExtension using AMPscript
Raw
Delete a record from DataExtension using AMPscript.html
%%[
SET @status = DeleteData("DataExtension Name", "SubscriberKey","XXXXXXXXXX")
]%%
Status: %%=v(@status)=%%
@katydorjee
Copy link
Author

katydorjee commented Sep 11, 2020 •
edited

Converting to SSJS:

<script runat='server'>
Platform.Load('Core','1');
try{
var DE_name = 'XYZ';
var FeildName = 'SubscriberKey';
var FeildValue = 'XXXXXXXXXX';
var ampscriptStr = '%'+'%[SET @deleteCount = DeleteData("'+DE_name+'","'+FeildName+'","'+FeildValue+'")]%'+'%';
Platform.Function.TreatAsContent(ampscriptStr);
Write(Platform.Variable.GetValue("@deleteCount"));
}catch (ex){
Write(Stringify(ex));
}
</script>

@katydorjee
Copy link
Author

https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/deletedata.htm

@katydorjee
Copy link
Author

also refer to https://gist.github.com/katydorjee/069c9dc16e79d5d5dc2d124ecd4eb0a8

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment