TypeError:无法读取未定义的属性"pair" [英] TypeError: Cannot read property 'pair' of undefined

问题描述

我一直在尝试学习Google表格的脚本.以下返回正确的结果.但是，它停止了我的脚本并显示以下错误.任何帮助将不胜感激.

I've been fumbling through trying to learn scripting for google sheets. The following returns the correct results. But, it stops my script and shows the following error. Any help would be much appreciated.

TypeError:无法读取未定义的属性"pair"

TypeError: Cannot read property 'pair' of undefined

  var sh1=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("SCRIPT_DATA");
  var requestOptions = {
  'method': 'GET',
 https://api.incscan.io/pdex/overview,
{
start: 1,
limit: 5000,

  },
  json: true,
  gzip: true
};
var url='https://api.incscan.io/pdex/overview';

var result= UrlFetchApp.fetch(url, requestOptions);
var txt= result.getContentText();
var d=JSON.parse(txt);

    for (var i=0; i<100;i++)

{
  sh1.getRange(i+2, 7).setValue(d.perPair[i].pair);
  sh1.getRange(i+2, 8).setValue(d.perPair[i].liquidity);
  sh1.getRange(i+2, 9).setValue(d.perPair[i].volume);
}
  sh1.getRange(2, 12).setValue(d.liquidity);   
  sh1.getRange(2, 13).setValue(d.allTimeVolume);

推荐答案

仅对可用数据进行循环

for (let i = 0; i < d.perPair.length; i++) {
  sh1.getRange(i + 2, 7).setValue(d.perPair[i].pair);
  sh1.getRange(i + 2, 8).setValue(d.perPair[i].liquidity);
  sh1.getRange(i + 2, 9).setValue(d.perPair[i].volume);
}

这篇关于TypeError:无法读取未定义的属性"pair"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！