Josh Josh - 25 days ago 7
JSON Question

How to parse JSON response in Google App Script?

I'm using a Google AdWords/App Script and I got this response from DoubleClick Search. I'm trying to parse it to put in a Sheet/ into an array to work with and I'm not having much luck. Thank you for taking a look.

This is the original code:

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"
}
]
}

Answer

It is similar to regular JavaScript. You get the JSON response with UrlFetchApp service and then access the properties using the dot notation.

var response = authUrlFetch.fetch(url, options);
var data = JSON.parse(response.getContentText());
Logger.log(data.request.reportType);