我正在使用Google AdWords/App脚本,并从DoubleClick搜索中收到此响应。我正在尝试解析此响应,以便将其放入工作表/数组中进行处理,但没有太多运气。感谢您查看。
这是原始代码:
var response = authUrlFetch.fetch(url, options);
var data = JSON.stringify(response.getContentText());
var parsedData = JSON.parse(data);
{
"kind": "doubleclicksearch#report",
"request": {
"reportType": "advertiser",
"columns": [
{
"columnName": "agency"
},
{
"columnName": "agencyId"
},
{
"columnName": "advertiser"
},
{
"columnName": "advertiserId"
}
],
"includeRemovedEntities": false,
"statisticsCurrency": "usd",
"startRow": 0,
"rowCount": 10000
},
"statisticsCurrencyCode": "USD",
"rowCount": 2,
"rows": [
{
"agency": "a",
"agencyId": "11111111111111",
"advertiser": "aa",
"advertiserId": "11111111111111"
},
{
"agency": "b",
"agencyId": "222222222222222",
"advertiser": "bb",
"advertiserId": "22222222222"
}
]
}
2条答案
按热度按时间dzjeubhm1#
它类似于普通的JavaScript,用UrlFetchApp服务得到JSON响应,然后用点符号访问属性。
4nkexdtk2#
使用API时第一个答案的变化