Is there a way to get the count of a data-extensions without pulling in all of its rows, and counting them? (from api)

I can't find a size property of the data-extension, but I assume this functionality is somehow possible, as the ET Dashboard does have the size's of all there data-extensions.



Unfortunately, no. Best work-around I've seen is to create a Query Activity that counts the rows of the Data Extension on some interval. Then you can simply retrieve the resulting data via API (DataExtensionObject).


An alternate method is outlined here, if you have Cloud Pages enabled.


Another potential workaround would be to use the Action of GetMaxCount with the Perform method. This would require that an EmailSendDefinition exist in the account where the data extension of interest is the target. This would only be good if you wanted a quick total right before sending, if you wanted to see a large list of DEs with their counts then this would not be a very performant option.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.