时间戳

首页 > 解决方案 > 谷歌脚本 - 解析 json 响应

google-apps-script - 谷歌脚本 - 解析 json 响应

问题描述

这是我试图解析的 json响应（来自我的多项选择字段jsfiddle ）：

{"selected":true,"disabled":false,"text":"Ctr","id":"Ctr","title":"","_resultId":"select2-selectcountry-result-je97-Ctr “，“元素”：{}}，

{"selected":true,"disabled":false,"text":"Title Part1","id":"TitlePart1","title":"","_resultId":"select2-selectcountry-result-uv7s- TitlePart1","元素":{}},

{"selected":false,"disabled":false,"text":"Milan","id":"Milan","_resultId":"select2-selectcountry-result-bmba-Milan","element":{ }}]

我需要得到： {" id ":value},{" id ":value},{" id ":value} ...

{id:Ctr},{"id":"TitlePart1"},{"id":"Milan} ...

为了达到这个结果，我使用了这段代码：

var response = (JSON.stringify($('#selectcountry').select2('data')) );        
var json = JSON.parse(response);
        var dataSet = json;
        var row = [],
        data;
       for(var i in json){
       data = dataSet[i];
       row.push({'id': json[i].id})
       }

   sheet.getRange(6,1).setValue(row);

但通过这种方式，我只得到第一个 id:value:

{id:Ctr}

有什么帮助吗？

谢谢

标签： google-apps-scriptgoogle-sheetsjsonparser

解决方案

var s='[{"selected":true,"disabled":false,"text":"Ctr","id":"Ctr","title":"","_resultId":"select2-selectcountry-result-je97-Ctr","element":{}},{"selected":true,"disabled":false,"text":"Title Part1","id":"TitlePart1","title":"","_resultId":"select2-selectcountry-result-uv7s-TitlePart1","element":{}},{"selected":false,"disabled":false,"text":"Milan","id":"Milan","_resultId":"select2-selectcountry-result-bmba-Milan","element":{}}]';

function findId() {
  var d=JSON.parse(s);
  var ids=[];
  d.forEach(function(o){
    ids.push(o.id);
  });
  Logger.log(ids);
  //Add this
  SpreadsheetApp.getActiveSheet().getRange(1,1,1,3).setValues([ids]);
}

推荐阅读