Maximiliano
01/13/2024, 10:18 PMAttempting to load workbook with ID: 30
var log, workbook, response = new Object();
define(['N/log', 'N/workbook'], main);
function main(logModule, workbookModule) {
log = logModule;
workbook = workbookModule;
return { post: postProcess };
}
function postProcess(request) {
try {
if (
typeof request.workbookID === 'undefined' ||
request.workbookID === null ||
request.workbookID === ''
) {
throw {
type: 'error.WorkbookAPIError',
name: 'INVALID_REQUEST',
message: 'No workbookID was specified.',
};
}
log.debug('Attempting to load workbook with ID: ' + request.workbookID);
// Attempt to load workbook
var myWorkbook;
try {
myWorkbook = workbook.load({
id: request.workbookID
});
} catch (loadError) {
log.error({
title: 'Error loading workbook',
details: loadError
});
throw {
type: 'error.WorkbookLoadError',
name: 'UNABLE_TO_LOAD_WORKBOOK',
message: 'Unable to load workbook: ' + loadError.message
};
}
var sheets = myWorkbook.getSheets();
var allData = {};
sheets.forEach(function (sheet) {
var sheetName = sheet.getTitle();
var data = sheet.getAllValues(); // Retrieve all data from the sheet
allData[sheetName] = data;
});
response.results = allData;
return response;
} catch (e) {
log.error({
title: 'Script Error',
details: e
});
return { error: { type: 'SCRIPT_ERROR', message: 'Error in script execution.' } };
}
}
battk
01/13/2024, 11:49 PMbattk
01/13/2024, 11:50 PMMaximiliano
01/14/2024, 12:02 AMbattk
01/14/2024, 12:30 AMMaximiliano
01/14/2024, 1:16 AMMaximiliano
01/14/2024, 1:22 AMbattk
01/14/2024, 1:50 AMbattk
01/14/2024, 1:50 AMbattk
01/14/2024, 1:50 AMbattk
01/14/2024, 1:51 AM