title: Importjson to google spreadsheet, one field gives several results
body: <p>I am trying to make a tracking system for our post @ work, and so far I feel that I am 90% done, but I get one problem. </p>
  
  <p>I have added this script to google spreadsheet:<a href="https://gist.githubusercontent.com/chrislkeller/5719258/raw/46da3483d6d444c4c1d0bcae666a366636561db5/import_json_appsscript.js" rel="nofollow noreferrer">https://gist.github.com/chrislkeller/5719258</a></p>
  
  <p>Now, I am trying to pull out data with this "command":</p>
  
  <pre><code>=ImportJSON("https://tracking.bring.com/api/tracking.json?q="&amp;A4;"/consignmentSet/packageSet/eventSet/recipientSignature,/consignmentSet/packageSet/eventSet/status,/consignmentSet/senderReference,/consignmentSet/packageSet/productName";"noInherit,noHeaders")
  </code></pre>
  
  <p>And this works, but it gives me multiple results on status:</p>
  
  <pre><code>/consignmentSet/packageSet/eventSet/status
  </code></pre>
  
  <p>If you see source, it have several "STATUS" in the source <a href="https://tracking.bring.com/api/tracking.json?q=TESTPACKAGE-AT-PICKUPPOINT" rel="nofollow noreferrer">https://tracking.bring.com/api/tracking.json?q=TESTPACKAGE-AT-PICKUPPOINT</a>, and this is the reason why it get all the results. What I want, is to get the last result for status in my google spreadsheet. This to give it a more clean look, and also to have less used cells for no use. The url provided, is a test package for bring, but when we send out, it will get even more "STATUS" up to 5 different status.</p>
  
  <p>TLDR: Want to get one result for status, not several as shown in--> <a href="https://tracking.bring.com/api/tracking.json?q=TESTPACKAGE-AT-PICKUPPOINT" rel="nofollow noreferrer">https://tracking.bring.com/api/tracking.json?q=TESTPACKAGE-AT-PICKUPPOINT</a> when importing data to google spreadsheet. </p>