Server Side JavaScript to create a filtered data extension?

Question

The Salesforce documentation provides helpful examples of creating regular data extensions using SSJS, but no example for creating a filtered one. Does anyone have a code sample for creating a filtered data extension? I'm unsure of the syntax that would need to be used. Thanks!

Answer 1

I've done this with WSProxy:

<script runat="server">

  Platform.Load("Core","1");

  var prox = new Script.Util.WSProxy();
  var filterName = "TestFilter"
  var filterSourceDEKey = "TestDEKey"
  var filterCategoryId = 1234 // folder in which to create the filter 
  var DEFieldVal1 = "whee"
  var DEFieldVal2 = "whoa"

  var sfp1 = {"__Type__": "SimpleFilterPart", Property: "DEField1", SimpleOperator: "equals", Value: [DEFieldVal1]};
  var sfp2 = {"__Type__": "SimpleFilterPart", Property: "DEField2", SimpleOperator: "equals", Value: [DEFieldVal2]};
  var cfp = {
                "__Type__": "ComplexFilterPart"
              , LeftOperand: sfp1
              , LogicalOperator: "AND"
              , RightOperand: sfp2
            };

  var filterDefinition = {
       "Name": filterName
     , "CustomerKey" : filterName
     , "DataSource" : { "__Type__": "DataExtension", "CustomerKey" : filterSourceDEKey }
     , "DataFilter" : cfp // you can also just use a SimpleFilterPart here instead of a complex one
     , "CategoryID" : filterCategoryID
  };

  var result = prox.createItem("filterDefinition", filterDefinition);

  if (debug) {
    Write("<br>result: " + Stringify(result));
  }

</script>

Answer 2

Filtered data extension comes from the main data extension from which you want to filter a data. I don't think you need ssjs to create a filtered data extension. You can simply click on create in DE and from the type of DE choose filtered DE and the source DE you want to filter it from. You filtered DE will be created.