I am trying to use SSJS to retrieve the DE names of all DE's in a particular folder (folderid = 14273), and save them in an upsert DE (DE name = DEDE). The below script runs successfully in automation studio but when I check back DEDE, no rows are generated. I also tried testing by hardcoding the name of just 1 DE in the folder but that didn't work either.

The upsert DE has 2 fields, Name (primary key, text, max 300 characters) and CreatedDate (date, nullable)


    <script runat="server">
    Platform.Load("core", "1");

    var api = new Script.Util.WSProxy();
    var folderID = "14273"; 
    var targetDE = DataExtension.Init("DEDE"); 

    try {
        var req = api.retrieve("DataExtension", ["Name"], {
            Property: "CategoryID",
            SimpleOperator: "equals",
            Value: folderID
        });

        if (req.Results.length > 0) {
            for (var i = 0; i < req.Results.length; i++) {
                var deName = req.Results[i].Name;
                var data = [
                    {
                        Name: deName
                    }
                ];

                targetDE.Rows.Upsert(["Name"], data);
            }
        }
    } catch (error) {
    }
</script>