Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
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?