0

Hi i am unable to create a dynamic data extension from the existing data extension fields. I am using the following code to get that

<script runat="server">
Platform.Load("core","1.2");
var dummyDE = DataExtension.Init("80c489be-20f3-448b-b683-2b098cae20dc");
var fields = dummyDE.Fields.Retrieve();
var DE = "MyDataExtension1", FolderName = "Amit";
var FolderAttributes = Folder.Retrieve({
  Property: "Name",
  SimpleOperator: "equals",
  Value: FolderName
});
var FolderID = FolderAttributes[0].ID;  
var obj = {
  "CustomerKey" :"XYZ",
  "Name": DE,
  "CategoryID": FolderID,
  "Fields": fields
}
var Status = DataExtension.Add(obj);
</script>

1 Answer 1

0

The only issue with your code is that you are not referencing a valid Core Library version. Try:

Platform.Load("core","1.1.1");

The only other thing to be aware of is, if you have multiple folders named "Amit", then the retrieve function will return multiple objects in the array. Not specifying the exact folder you need may result in the DE being created in a different folder to the one you were expecting.

2
  • thanks for the help but the issue i found out is with fields. Fields are not getting assigned to DE fields thats why the de is not getting formed . Can u please help on that point , If i pass the regular fields to obj DE is getting formed
    – user69816
    Commented Jun 17, 2019 at 5:33
  • Use Write(Stringify(fields)) to see the structure of the fields object, and ensure it's matching with the required structure in the Add DE documentation Commented Jun 17, 2019 at 23:20

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .