Scribd
Upload
161 views1 page

Log Temperature and Humidity Data

This document defines a doGet function that logs request parameters, writes data to a spreadsheet, and returns a response. It logs the request, checks for parameters, gets the last row of a spreadsheet, iterates through parameters to write their values to columns, and returns the result.

Uploaded by

Felipe Andrés Carvajal Cid
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
161 views1 page

Log Temperature and Humidity Data

This document defines a doGet function that logs request parameters, writes data to a spreadsheet, and returns a response. It logs the request, checks for parameters, gets the last row of a spreadsheet, iterates through parameters to write their values to columns, and returns the result.

Uploaded by

Felipe Andrés Carvajal Cid
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

function doGet(e) {

[Link]( [Link](e) );
var result = 'Ok';
if ([Link] == 'undefined') {
result = 'No Parameters';
}
else {
var sheet_id = ''; // Spreadsheet ID
var sheet = [Link](sheet_id).getActiveSheet();
var newRow = [Link]() + 1;
var rowData = [];
var Curr_Date = new Date();
rowData[0] = Curr_Date; // Date in column A
var Curr_Time = [Link](Curr_Date, "Asia/Jakarta", 'HH:mm:ss');
rowData[1] = Curr_Time; // Time in column B
for (var param in [Link]) {
[Link]('In for loop, param=' + param);
var value = stripQuotes([Link][param]);
[Link](param + ':' + [Link][param]);
switch (param) {
case 'temperature':
rowData[2] = value; // Temperature in column C
result = 'Temperature Written on column C';
break;
case 'humidity':
rowData[3] = value; // Humidity in column D
result += ' ,Humidity Written on column D';
break;
default:
result = "unsupported parameter";
}
}
[Link]([Link](rowData));
var newRange = [Link](newRow, 1, 1, [Link]);
[Link]([rowData]);
}
return [Link](result);
}
function stripQuotes( value ) {
return [Link](/^["']|['"]$/g, "");
}

You might also like