NisseDILLIGAF

Spark to google spreadsheet

Jan 28th, 2014
873
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function myFunction() {
  2.  
  3.   var payload =
  4.       {
  5.         "access_token" : "1234123412341234123412341234123412341234"
  6.       };
  7.  
  8.   // Because payload is a JavaScript object, it will be interpreted as
  9.   // an HTML form. (We do not need to specify contentType; it will
  10.   // automatically default to either 'application/x-www-form-urlencoded'
  11.   // or 'multipart/form-data')
  12.  
  13.   var options =
  14.       {
  15.         "method" : "post",
  16.         "payload" : payload
  17.       };
  18.  
  19.   var result = UrlFetchApp.fetch("https://api.spark.io/v1/devices/0123456789abcdef01234567/readTemp", options); // calls 'readTemp' function
  20.   var o  = Utilities.jsonParse(result.getContentText());
  21.  
  22.   doGet(o);
  23. }
  24.  
  25.  
  26. function doGet(e) {  
  27.   Logger.log( JSON.stringify(e) );  // view parameters
  28.  
  29.   var id = 'FGHFGHFFFGHHGHFGHFGHFGHDTLJFGHFGHJ0E'; // Spreadsheet id
  30.   var sheet = SpreadsheetApp.openById(id).getActiveSheet();
  31.  
  32.  
  33.  
  34.   var newRow = sheet.getLastRow() + 1;
  35.   var rowData = [];
  36.  
  37.   rowData[0] = new Date(); // Timestamp
  38.   rowData[1] = (e.return_value/100);
  39.  
  40.   Logger.log(JSON.stringify(rowData));
  41.  
  42.   // Write new row to spreadsheet
  43.   var newRange = sheet.getRange(newRow, 1, 1, rowData.length);
  44.   newRange.setValues([rowData]);
  45.  
  46.  
  47.  
  48. }
Add Comment
Please, Sign In to add comment