Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function myFunction() {
- var payload =
- {
- "access_token" : "1234123412341234123412341234123412341234"
- };
- // Because payload is a JavaScript object, it will be interpreted as
- // an HTML form. (We do not need to specify contentType; it will
- // automatically default to either 'application/x-www-form-urlencoded'
- // or 'multipart/form-data')
- var options =
- {
- "method" : "post",
- "payload" : payload
- };
- var result = UrlFetchApp.fetch("https://api.spark.io/v1/devices/0123456789abcdef01234567/readTemp", options); // calls 'readTemp' function
- var o = Utilities.jsonParse(result.getContentText());
- doGet(o);
- }
- function doGet(e) {
- Logger.log( JSON.stringify(e) ); // view parameters
- var id = 'FGHFGHFFFGHHGHFGHFGHFGHDTLJFGHFGHJ0E'; // Spreadsheet id
- var sheet = SpreadsheetApp.openById(id).getActiveSheet();
- var newRow = sheet.getLastRow() + 1;
- var rowData = [];
- rowData[0] = new Date(); // Timestamp
- rowData[1] = (e.return_value/100);
- Logger.log(JSON.stringify(rowData));
- // Write new row to spreadsheet
- var newRange = sheet.getRange(newRow, 1, 1, rowData.length);
- newRange.setValues([rowData]);
- }
Add Comment
Please, Sign In to add comment