eBay API将XML解析为Google脚本时出现问题

我正在尝试调用eBay API GetMyeBaySelling，我可以让Act，Timestamp，Version和Build返回并将其写入Google表格，但是无论如何，我都无法返回“ Item”列表。响应在下面，我需要获得其他任何字段的帮助。可以说我想遍历所有返回的清单并返回“ BuyItNowPrice”。我已经尝试了下面的代码，但很快就没了。

我更习惯于Excel VBA，但尝试过渡到Google表格脚本。

API响应：

[20-09-15 19:52:46:012 BST] Logging output too large. Truncating output. <?xml version="1.0" encoding="UTF-8"?>
<GetMyeBaySellingResponse xmlns="urn:ebay:apis:eBLBaseComponents"><Timestamp>2020-09-15T18:52:45.627Z</Timestamp><Ack>Success</Ack><Version>1163</Version><Build>E1163_CORE_APISELLING_19187371_R1</Build><ActiveList><ItemArray><Item><BuyItNowPrice currencyID="GBP">3.99</BuyItNowPrice><ItemID>##########</ItemID><ListingDetails><StartTime>2011-09-16T10:51:54.000Z</StartTime><ViewItemURL>https://www.ebay.co.uk/itm/???????????????????????????-/############</ViewItemURL><ViewItemURLForNaturalSearch>http://cgi.ebay.co.uk/????????item=############&amp;category=51169&amp;cmd=ViewItem</ViewItemURLForNaturalSearch></ListingDetails><ListingDuration>GTC</ListingDuration><ListingType>StoresFixedPrice</ListingType><Quantity>70</Quantity><SellingStatus><CurrentPrice currencyID="GBP">3.99</CurrentPrice></SellingStatus><ShippingDetails><ShippingServiceOptions><ShippingServiceCost currencyID="GBP">0.0</ShippingServiceCost></ShippingServiceOptions><ShippingType>Flat</ShippingType></ShippingDetails><TimeLeft>PT15H59M9S</TimeLeft><Title>????????????????????????????</Title><WatchCount>3</WatchCount><QuestionCount>3</QuestionCount><QuantityAvailable>0</QuantityAvailable><SKU>???????</SKU><PictureDetails><GalleryURL>http://thumbs.ebaystatic.com/pict/???????????_5.jpg</GalleryURL></PictureDetails><NewLeadCount>3</NewLeadCount><ClassifiedAdPayPerLeadFee currencyID="GBP">0.0</ClassifiedAdPayPerLeadFee><SellerProfiles><SellerShippingProfile><ShippingProfileID>??????????</ShippingProfileID><ShippingProfileName>Flat:Royal Mail 2nd(Free),Royal Mail Tra,Same#79</ShippingProfileName></SellerShippingProfile><SellerReturnProfile><ReturnProfileID>????????????</ReturnProfileID><ReturnProfileName>Returns Accepted,Buyer,30 days#2</ReturnProfileName></SellerReturnProfile><SellerPaymentProfile><PaymentProfileID>124284320022</PaymentProfileID><PaymentProfileName>PayPal#0</PaymentProfileName></SellerPaymentProfile></SellerProfiles><HideFromSearch>true</HideFromSearch><ReasonHideFromSearch>OutOfStock</ReasonHideFromSearch><OutOfStockControl>true</OutOfStockControl></Item><Item>

我的代码：

    var response = UrlFetchApp.fetch(site, options);

  
   var document = XmlService.parse(response);
  Logger.log(response);
  var root = document.getRootElement();
  var NS = XmlService.getNamespace("urn:ebay:apis:eBLBaseComponents");
   
  var ack = root.getChildText('Ack', NS);
  var time = root.getChildText('Timestamp', NS);
  var version = root.getChildText('Version', NS);
  var build = root.getChildText('Build', NS);
  var shortmessage = root.getChildText('ShortMessage', NS);
   //Logger.log(shortmessage);  
  var longmessage = root.getChildText('LongMessage', NS);
   //Logger.log(longmessage);
  
  var itms = root.getChild('ActiveList', NS).getChild('ItemArray', NS).getChild('BuyItNowPrice', NS);
        Logger.log(itms + '1st Log');
  for (var i = 0; i < itms.length; i++) {
    var item = itms[i].getChild('Item', NS).getText();
      Logger.log(item + '2nd Log');
  }

    //sheet.getRange('A2').setValue(xml);
   var LstSheet = sheet.getLastRow()+1
   sheet.getRange(LstSheet, 1).setValue([ack]);
   sheet.getRange(LstSheet, 2).setValue([time]);
   sheet.getRange(LstSheet, 3).setValue([version]);
   sheet.getRange(LstSheet, 4).setValue([build]);
   sheet.getRange(LstSheet, 5).setValue([shortmessage]);
   sheet.getRange(LstSheet, 6).setValue([longmessage]);

提前致谢

更新：16-09-2020 @ 17：08hrs英国：好的，我现在有正常工作的代码，它将数据写入工作表，但是在4列中写入200条记录大约需要82秒。将数据写入数组然后将其添加到工作表会更快吗？如果速度更快，您可以举个例子。实际上，最好还是看看如何将其写入数组，然后再写入工作表，这样我才能学到更多。

我的工作代码：

  var itms = root.getChild('ActiveList', NS).getChild('ItemArray', NS).getChildren();
  for (var i = 0; i < itms.length; i++) {
    
    var item = itms[i].getChild('ItemID', NS).getText();
    var title = itms[i].getChild('Title', NS).getText()
    var url = itms[i].getChild('ListingDetails', NS).getChild('ViewItemURLForNaturalSearch', NS).getText()
    var imgurl = itms[i].getChild('PictureDetails', NS).getChild('GalleryURL', NS).getText()
    
    
    sheet.appendRow([item, title, url, imgurl]);