I am trying to print the JSON values from the Rows.Retrieve function of SSJS but it always returns null
var stagingDE = DataExtension.Init("DE's External Key");
var data = stagingDE.Rows.Retrieve();
var newString = JSON.stringify(data, null, '\t');
Write("The Value " + newString );
Is there anything I am missing?
Try the following, I usually just call the Stringify() function from the Platform Functions of SSJS directly and check for a typeof 'Object' and length before I do anything with the response data.
I have not tested the below but it should work assuming the Data Extension External Key is correct and located within the same Business Unit you are executing the SSJS.
<script runat="server">
Platform.Load('core', '1');
var stagingDE = DataExtension.Init("DE's External Key");
var data = stagingDE.Rows.Retrieve();
if (typeof(data) == 'object' && data.length > 0) {
Write("The Value " + Stringify(data));
} else {
Write("No Rows Found");
}
</script>
