报错提示:Error:Code: ExecuteFailed, Message: undefined
at fetchAllRecords (汇总.js:12:45)
at 汇总.js:4:14
说明:要读取的轻维表文档是别人分享的,拥有可编辑权限
const file = KSDrive.openFile("https://kdocs.cn/l/ctvn3EbV6zUN");
const views = file.Application.View.GetViews({ SheetId: 38 });
console.log(views);//可以运行,打印结果没问题
const recs = fetchAllRecords(file,38,'C'); //报错
console.log(recs);
file.close();
function fetchAllRecords(file,sheetId,viewId) {
let all = [];
let offset = null;
while (all.length === 0 || offset) {
let records = file.Application.Record.GetRecords({
SheetId: sheetId,
ViewId: viewId,
Offset: offset
});
offset = records.offset;
all = all.concat(records.records);
};
return all;
};