verified
Retrieve all Data ExtensionsLearn 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.