title: Reading Data from API response
body: <p>I'm trying to get specific data from a website API.</p>
  <p>This is what I have, which just dumps the entire response into google sheets then I use mid to pull the correct string.</p>
  <p>Is there a way to just return the value of &quot;unpaid&quot;?</p>
  <p>Here is the response I get:</p>
  <pre><code>{&quot;status&quot;:&quot;OK&quot;,&quot;data&quot;:{&quot;time&quot;:1612834200,&quot;lastSeen&quot;:1612834035,&quot;reportedHashrate&quot;:154783794,&quot;currentHashrate&quot;:131055555.55555557,&quot;validShares&quot;:116,&quot;invalidShares&quot;:0,&quot;staleShares&quot;:3,&quot;averageHashrate&quot;:150218750,&quot;activeWorkers&quot;:3,&quot;unpaid&quot;:26075516667066776,&quot;unconfirmed&quot;:null,&quot;coinsPerMin&quot;:0.00000787562193181224,&quot;usdPerMin&quot;:0.013755797534761213,&quot;btcPerMin&quot;:2.9738348414523017e-7}}
  </code></pre>
  <p>All I want out of it is</p>
  <pre><code>&quot;unpaid&quot;:26075516667066776
  </code></pre>
  <p>Below is the script I'm using to pull that data into google sheets.</p>
  <pre><code>function callNumbers() {
    var response = UrlFetchApp.fetch(&quot;&quot;);
    Logger.log(response.getContentText());
    
    var data = response.getContentText();
    var sheet = SpreadsheetApp.getActiveSheet();
    sheet.getRange(49,7).setValue([data]);
  
  }
  </code></pre>
  <p>I can't seem to find much information on this, or I just don't know where to look. I got the above functions from a google page and then adapted them to pull the information from the website address that I wanted.</p>
  <p>Thanks</p>