Discussions
Cannot load a dataset in script
Hello NetSuite Gurus,
I tried to debug this script to load a dataset in Analytics:
require(['N/query'], function (query) {
try {
var datasetId = '72';
// Load the dataset
var dataset = query.load({
id: datasetId
});
// Run the dataset
var resultSet = dataset.run();
var results = [];
var iterator = resultSet.iterator();
iterator.each(function (row) {
var values = row.valueAsMap;
results.push(values);
return true;
});
log.debug('results',results);
} catch (e) {
	log.debug(e.name + ': ' + e.message);
}
});
However, the script showed the error:
I ran the script in Script debugger with Admin role.
I was able to open the dataset:
Could you please help me on this issue? Based on the screenshots of dataset, is 72 a dataset id I can use to load in the script? If so, why could the script not find that dataset?