Retrieve all Data Extensions verified

Learn how to retrieve all Data Extensions in Salesforce Marketing Cloud (SFMC) with SSJS (server-side JavaScript). Code snippets include the WSProxy method.

WSProxy

var req = api.retrieve("DataExtension", ["Name"], {
    Property: "CustomerKey",
    SimpleOperator: "isNotNull",
    Value: " "
});

var result = [];

var results = req.Results;

for (var k in results) {
    var name = results[k].Name;
    if (name.indexOf("_") != 0) result.push(name);
}

<script runat="server">

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

    var api = new Script.Util.WSProxy();
	
	try {

        var result = [],
            moreData = true,
            reqID = data = null;

        while(moreData) {

            moreData = false;

            if (reqID == null) {

                var req = api.retrieve("DataExtension", ["Name"], {
                    Property: "CustomerKey",
                    SimpleOperator: "isNotNull",
                    Value: " "
                });

            } else {
                var req = api.getNextBatch("DataExtension", reqID);
            }

            if (req != null) {

                moreData = req.HasMoreRows;
                reqID = req.RequestID;

                var results = req.Results;

                for (var k in results) {
                    var name = results[k].Name;
                    if (name.indexOf("_") != 0) result.push(name);
                }

            }
        }

        Write(Stringify(result));
		
	} catch(error) {
        Write(Stringify(error));
    }	

</script>

[
    "MyDataExtension",
    "MyDataExtension1",
    "MyDataExtension2"
]

Reference

Ressources and references related to the current methods.

Official documentation

SOAP object

Help me turn coffee into code

This website is provided to you free of charge. However, a lot of time and effort are spent to write, test and mainain the code. Please consider supporting my work by buying me a cup of coffee.

Buy me a coffee