I already know how to create a data filter, I would like to know how to create a data extension with selected data filter via API call. It should create a new data extension with same schema as the source data extension and import the rows matching the filter (simple filterpart) condition.

I can only find the guide on how to create standard or template-based data extension via API on ET's help site. Any ideas?


The ability to create a Filter Activity to run a filter is not currently exposed in the API. It would be possible to do something similar using Query activities. It wouldn't auto-create the target DE, that would have to be created first so it probably isn't as slick as you were hoping but is an option:

  1. Retrieve existing DataExtension and DataExtensionFields objects for target Data Extension
  2. Create new DataExtension object using the information from step 1
  3. Create QueryActivity with the necessary filter criteria
  4. Perform QueryActivity
  • thank you, I did it successfully. One issue is I cannot retrieve DisplayOrder or Nillable properties of a data extension field, it throws an error says "The Request Property(s) IsNillable do not match with the fields of DataExtensionField retrieve". So for the new data extension I cannot 100% copy the schema from original DE
    – Bo Hu
    Jan 28 '16 at 22:22
  • IsRequired is actually what you are looking for, not IsNillable. For the order, the field is Ordinal instead of DisplayOrder.
    – Mac
    Jan 29 '16 at 13:45
  • cool, will use them instead, cheers!
    – Bo Hu
    Jan 31 '16 at 22:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.