[SalesForce] Remove subscriber(s) from list via script

I'm pretty new at SSJS, but I'm trying to run a script in automation studio that removes a subscriber from a list via the unsubscribe function (see: https://developer.salesforce.com/docs/atlas.en-us.mc-programmatic-content.meta/mc-programmatic-content/ssjs_listSubscribersUnsubscribe.htm)

The javascript is valid according to Automation Studio and it also runs without error. However, the subscriber is not removed from the list.

My script is as follows and the email address I am referring to exists within the list:

Platform.Load("core","1");   
var myList = List.Init("DeleteDelta");      
var status myList.Subscribers.Unsubscribe("totalnonsense@nonsense.com");

Hopefully someone can tell me what I am doing wrong!

Best Answer

@Rutger Vogelsang this code for deleting all subscriber from particular list

  <script runat="server">
 Platform.Load("Core","1");
var  myList = List.Init("external key here");
var listFields = myList.Subscribers.Retrieve();
 var listFieldsLength = listFields.length;
 if (listFieldsLength > 0) {
    for (var i = 0; i < listFieldsLength; i++) {
 var subObj = Subscriber.Init(listFields[i].SubscriberKey);
   var status = subObj.Remove();
    }
 }

Related Solutions

[SalesForce] SSJS Functions in Automation Studio

Platform.Load (used to load the core library) is case sensitive. You will need to use Platform.Load instead of platform.load.

Also, I would recommend removing the comma after the Field 3 object in your array. It will work if you include it, but it's not strictly valid.

The following code works. However, note that the script will fail if a DE already exists with the same name and external key.

<script runat="server">
Platform.Load("core","1.1");
var deObj = {
    "CustomerKey" : "demoDE",
    "Name" : "My Demo DE",
    "Fields" : [
      { "Name" : "Field 1", "FieldType" : "Number", "IsPrimaryKey" : true, "IsRequired" : true },
      { "Name" : "Field 2", "FieldType" : "Text", "MaxLength" : 50 },
      { "Name" : "Field 3", "FieldType" : "Date", "Ordinal" : 2 }
    ]
 };

var myDE = DataExtension.Add(deObj);
</script>

[SalesForce] Creating Query Definition with SSJS

When you are able to add your query manually in Automation Studio based on the definitions that you wrote above, then the code needs to work.

I have created a data extension named "errorlog" with the customer key of "errorlogkey". It has one field named "num". Then, I wrote my query based on that information.

At the end, the code below worked:

<script runat="server">
Platform.Load("Core","1.1") ;

var queryDef = { Name : "Example Query Definition",

CustomerKey : "myQueryDef",
TargetUpdateType : "Overwrite",
TargetType : "DE",

Target:{
Name:"errorlog",
CustomerKey : "errorlogkey"
},
QueryText : "SELECT SubscriberKey as num FROM EOL_test2"
};

var status = QueryDefinition.Add(queryDef);

var outDE=DataExtension.Init("errorlog"); // just to see the result

 outDE.Rows.Add(  {message:status});

</script>

For detailed information: http://emailpeer.com/creating-an-sql-query-in-ssjs/

Best Answer

Related Solutions

[SalesForce] SSJS Functions in Automation Studio

[SalesForce] Creating Query Definition with SSJS

Related Topic