google-apps-script - 如何将 JSON 信息提取到谷歌表格

Question

我正在尝试创建许可证跟踪表，但在将信息从公共 JSON 提取到 google 表并使用脚本编辑器对其进行格式化时遇到问题。我对编码比较陌生，可以使用任何帮助。该代码有点像我在 Stack Overflow 和其他网站上发现的不同事物的科学怪人。

function pullPermits() {

  // Call the Permit API to get Permit infrmation
  var permits = UrlFetchApp.fetch("URL");
  Logger.log(response.getContentText());

  var events = permits.getString();
  var sheet = SpreadsheetApp.getActiveSheet();

  var header = [["Uniquekey","Application Name","Application Status","Application Start Date","Application End Date","Primary Contact Last","Application Name", "Street Number From", "Street Number To","Direction","Street Name","Suffix", "Application Processed Date","Comments","Detail"]]
  var range = sheet.getRange(1,1,1,15);

  for (var i=0;i<events.length;i++) {
  var row=i+2;

  range.setValues(header);

  var details=[[permits,events[i].getUniquekey(), events[i].getApplicationname(), events[i].getApplicationstatus(), events[i].getApplicationstartdate(), events[i].getApplicationenddate(), events[i].getPrimarycontactlast(), events[i].getApplicationname(), events[i].getStreetnumberfrom(), events[i].getStreetnumberfrom(), events[i].getDirection(), events[i].getStreetname(), events[i].getSuffix(), events[i].getApplicationprocesseddate(),events[i].getComments,()events[i].getDetails()]];
  var range=sheet.getRange(row,1,1,15);
range.setValues(details);
}

接收语法错误

标签： google-apps-scriptgoogle-sheetsgoogle-drive-api