Count Data Extension records verified

Learn how to count Data Extension records (rows) in Salesforce Marketing Cloud (SFMC) with SSJS (server-side JavaScript). Code snippets include the Core and REST API methods.

Core

var result = TreatAsContent("\%\%=DataExtensionRowCount('" + de + "')=\%\%");

<script runat="server">

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

	try {

        var de = "MyDataExtension";

        var count = TreatAsContent("\%\%=DataExtensionRowCount('" + de + "')=\%\%");

        var result = (count != null && count.length > 0) ? Number(count) : 0;

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

</script>

25

REST API

var customerKey = "S0M3-GU1D-K3Y-G03SR1G4T-H3R3";

var endpoint = restInstanceUrl + "/data/v1/customobjectdata/key/" + customerKey + "/rowset?$pageSize=1";

var request = new Script.Util.HttpRequest(endpoint);
    request.emptyContentHandling = 0;
    request.retries = 2;
    request.continueOnError = true;
    request.setHeader("Authorization", "Bearer " + accessToken);
    request.method = "GET";
    request.contentType = "application/json";

var results = request.send();

var content = Platform.Function.ParseJSON(String(results.content));

var result = content.count;

<script runat="server">

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

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

    var restInstanceUrl = "https://YOUR_SUBDOMAIN.rest.marketingcloudapis.com/",
        accessToken     = "YOUR_REST_API_TOKEN";
	
	try {

        var customerKey = "S0M3-GU1D-K3Y-G03SR1G4T-H3R3";

        var endpoint = restInstanceUrl + "/data/v1/customobjectdata/key/" + customerKey + "/rowset?$pageSize=1";

        var request = new Script.Util.HttpRequest(endpoint);
            request.emptyContentHandling = 0;
            request.retries = 2;
            request.continueOnError = true;
            request.setHeader("Authorization", "Bearer " + accessToken);
            request.method = "GET";
            request.contentType = "application/json";

        var results = request.send();

        var content = Platform.Function.ParseJSON(String(results.content));

        var result = content.count;

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

        Write(Stringify(error));
        
    }	

</script>

25

WARNING

This method uses an undocumented endpoint, which can potentially be removed in the future releases.

Reference

Ressources and references related to the current methods.

Official documentation

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