“The coordinates or dimensions of the range are in

问题:

I am working on a Google Apps Script that links with a REST API and puts the data into a Google Sheet.

I have successfully done this once, but upon accessing some different data I get the error message

"The coordinates or dimensions of the range are invalid"

when they work perfectly fine on my other script. All data accessed is JSON so I am bit confused and is from the same source. The code I am using is:

function stats () {
  var logIn = {
    "Authorization" : "Basic " + Utilities.base64Encode("XXXX" + ':' + "XXXX")
  };

  var url = "XXXXX";
  var params = {
    "method":"GET",
    "headers":logIn, };

  var response = UrlFetchApp.fetch(url, params);
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("XXXX");              

  var dataAll = JSON.parse(response.getContentText()); //
  var dataSet = dataAll;

  var rows = [],
      data;

  for (i = 0; i < dataSet.length; i++) {
    data = dataSet[i];
    rows.push([XXXX]); //your JSON entities here
  }

  dataRange = sheet.getRange(1, 1, rows.length, 1); 
  dataRange.setValues(rows);
}

I have combined pieces of code from around the web and this works on my other script. The error appears on this line:

dataRange = sheet.getRange(1, 1, rows.length, 1);

I believe the issue is with the data I am accessing but I do not know how to alter the script for it to work.

The JSON data that works is shown like:

{
  id: XXX,
  group: XX,
  text: "XXXX?",
  creation_date: XXXX,
  created_by: "XXXXX",
  tags: [
    "XXXX"
  ]
}

And the data that is causing the error is shown as:

    {
      2016-02-29: {
      XXX: 0,
      XXX: 0
    },

I have had to 'XXXX' out a lot of the private information - apologies. Any help would be appreciated.

回答1:

Javascript's length property is for indexed arrays and does not apply to Objects so dataSet.length returns undefined and the loop never executes.

To get the length of the object you can use Object.keys(dataSet).length as outlined here.