title: JSON.parse() with nested JSON
body: <p>I have a google-script that calls a CRM system, parses the JSON and appends it to the sheet. It works for some endpoints and not others. When it works, the values in the g-sheet, when it doesn't it just doesn't find any values. Code:</p>
  
  <pre><code>function thingy() {
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var sheets = ss.getSheets();
    var sheet = ss.getActiveSheet();
  
    var url    = "https://api.pipedrive.com/v1/mailbox/mailMessages/17685?include_body=1";
    var token  = "&amp;api_token=token"
  
    var response = UrlFetchApp.fetch(url+token); 
    var dataSet = JSON.parse(response.getContentText()); 
    var data;
  
    for (var i = 0; i &lt; dataSet.data.length; i++) {
      data = dataSet.data[i];
      sheet.appendRow([data.user_id]); 
    }
  }
  </code></pre>
  
  <p>Endpoint JSON that works, i can get title by using sheet.appendRow([data.title] :</p>
  
  <pre><code>{
  "success": true,
  "data": [
      {
          "stage_id": 6,
          "title": "Fakel",
          "value": 210,
          "currency": "EUR",
          "add_time": "2014-02-25 09:09:01"
      }
  </code></pre>
  
  <p>Endpoint JSON that does notworks, I can't get body with sheet.appendRow([data.body] :</p>
  
  <pre><code>{
  "data": {
      "id": 17685,
      "from": [
          {
              "id": 1411,
          }
      ],
      "to": [
          {
              "id": 1739,
          }
      ],
      "cc": [
          {
              "id": 199,
       }
      ],
      "bcc": [],
      "body": "blahblahblah"
  </code></pre>
  
  <p>I would also like to get the child entities as well. So I want to be able to get the ID in From, TO, CC. I'm guessing there is something different in the structure of the JSON that's preventing me to do it?</p>