轻表格读取另外一个轻维表文档报错的问题

阅读次数 106

报错提示:Error:Code: ExecuteFailed, Message: undefined at fetchAllRecords (汇总.js:12:45) at 汇总.js:4:14
说明:要读取的轻维表文档是别人分享的,拥有可编辑权限
(WR2JE9K80{PW@A3BWD__SQ.jpg

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;
};
0 Answers