diff options
author | Cristian Maglie <c.maglie@bug.st> | 2013-06-27 22:40:34 +0200 |
---|---|---|
committer | Cristian Maglie <c.maglie@bug.st> | 2013-06-27 22:40:34 +0200 |
commit | f34eaf039af4f442f4adf0ddb80e53a6cdaa5c2f (patch) | |
tree | c8cdb13fd419d4682f6a94f5145afc5ba7ad9dd4 /libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet | |
parent | ab4e82ddb038d8826d761c6ff5c9f08f63928cbd (diff) |
Temboo examples moved in their specific folder
Diffstat (limited to 'libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet')
-rw-r--r-- | libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet/SendDataToGoogleSpreadsheet.ino | 165 |
1 files changed, 165 insertions, 0 deletions
diff --git a/libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet/SendDataToGoogleSpreadsheet.ino b/libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet/SendDataToGoogleSpreadsheet.ino new file mode 100644 index 0000000..984bd53 --- /dev/null +++ b/libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet/SendDataToGoogleSpreadsheet.ino @@ -0,0 +1,165 @@ +/* + SendDataToGoogleSpreadsheet + + Demonstrates appending a row of data to a Google spreadsheet + from the Arduino Yun using the Temboo Arduino Yun SDK. + + A Temboo account and application key are necessary to run all Temboo examples. + If you don't already have one, you can register for a free Temboo account at + http://www.temboo.com + + This example assumes basic familiarity with Arduino sketches, and that your + Yun is connected to the Internet. For more tutorials on using the Temboo Library + and Temboo Arduino Yun SDK, visit http://www.temboo.com/arduino + + Since this sketch uses a Google spreadsheet, you'll also need a + Google account: substitute the placeholders below for your Google account values. + + The columns in your spreadsheet must have labels for the Choreo to + work properly. It doesn't matter what the column labels actually are, + but there must be text in the first row of each column. This example + assumes there are two columns. The first column is the time (in milliseconds) + that the row was appended, and the second column is a sensor value + (simulated in this example via a random number). + + This example code is in the public domain. + +*/ + +#include <Bridge.h> +#include <Console.h> +#include <FileIO.h> +#include <HttpClient.h> +#include <Process.h> +#include "TembooAccount.h" // contains Temboo account information, as described below + + +const unsigned long RUN_INTERVAL_MILLIS = 60000; // how often to run the Choreo (in milliseconds) + +// the last time we ran the Choreo +// (initialized to 60 seconds ago so the +// Choreo is run immediately when we start up) +unsigned long lastRun = (unsigned long)-60000; + +void setup() { + + // for debugging, wait until a serial console is connected + Serial.begin(9600); + delay(4000); + while(!Serial); + + Serial.print("Initializing the bridge..."); + Bridge.begin(); + Serial.println("Done"); +} + +void loop() +{ + // get the number of milliseconds this sketch has been running + unsigned long now = millis(); + + // run again if it's been 60 seconds since we last ran + if (now - lastRun >= RUN_INTERVAL_MILLIS) { + + // remember 'now' as the last time we ran the choreo + lastRun = now; + + Serial.println("Getting sensor value..."); + + // get the value we want to append to our spreadsheet + unsigned long sensorValue = getSensorValue(); + + Serial.println("Appending value to spreadsheet..."); + + // we need a Process object to send a Choreo request to Temboo + Process AppendRowChoreo; + + // invoke the Temboo client + AppendRowChoreo.begin("temboo"); + + // set Temboo account credentials + AppendRowChoreo.addParameter("-a"); + AppendRowChoreo.addParameter(TEMBOO_ACCOUNT); + AppendRowChoreo.addParameter("-u"); + AppendRowChoreo.addParameter(TEMBOO_APP_KEY_NAME); + AppendRowChoreo.addParameter("-p"); + AppendRowChoreo.addParameter(TEMBOO_APP_KEY); + + // identify the Temboo Library choreo to run (Google > Spreadsheets > AppendRow) + AppendRowChoreo.addParameter("-c"); + AppendRowChoreo.addParameter("/Library/Google/Spreadsheets/AppendRow"); + + // set the required Choreo inputs + // see https://www.temboo.com/library/Library/Google/Spreadsheets/AppendRow/ + // for complete details about the inputs for this Choreo + + // your Google username (usually your email address) + // NOTE: substitute your own value, retaining the "Username:" prefix. + AppendRowChoreo.addParameter("-i"); + AppendRowChoreo.addParameter("Username:your-google-username"); + + // your Google account password + // NOTE: substitute your own value, retaining the "Password:" prefix. + AppendRowChoreo.addParameter("-i"); + AppendRowChoreo.addParameter("Password:your-google-password"); + + // the title of the spreadsheet you want to append to + // NOTE: substitute your own value, retaining the "SpreadsheetTitle:" prefix. + AppendRowChoreo.addParameter("-i"); + AppendRowChoreo.addParameter("SpreadsheetTitle:your-spreadsheet-title"); + + // convert the time and sensor values to a comma separated string + String rowData(now); + rowData += ","; + rowData += sensorValue; + + // add the RowData input item + AppendRowChoreo.addParameter("-i"); + AppendRowChoreo.addParameter("RowData:" + rowData); + + // run the Choreo and wait for the results + // The return code (rc) will indicate success or failure + unsigned int rc = AppendRowChoreo.run(); + + // return code of zero (0) means success + if (rc == 0) { + Serial.println("Success! Appended " + rowData); + } else { + // return code of anything other than zero means failure + // read and display any error messages + while (AppendRowChoreo.available()) { + Serial.print((char)AppendRowChoreo.read()); + } + } + + AppendRowChoreo.close(); + } +} + +// this function simulates reading the value of a sensor +// in this example, we're generating a random number +unsigned long getSensorValue() { + return (unsigned long)random(0, 256); +} + +/* + IMPORTANT NOTE: TembooAccount.h: + + TembooAccount.h is a file referenced by this sketch that contains your Temboo account information. + You need to create this file. To do so, make a new tab in Arduino, call it TembooAccount.h, and + include the following variables and constants: + + #define TEMBOO_ACCOUNT "myTembooAccountName" // your Temboo account name + #define TEMBOO_APP_KEY_NAME "myFirstApp" // your Temboo app key name + #define TEMBOO_APP_KEY "xxx-xxx-xxx-xx-xxx" // your Temboo app key + + The same TembooAccount.h file settings can be used for all Temboo SDK sketches. + + Visit https://www.temboo.com/account to access your Temboo account credentials. + + Keeping your account information in a separate file means you can save it once, + then just distribute the main .ino file without worrying that you forgot to delete your credentials. + + (Be sure to delete this comment after creating your TembooAccount.h file!) +*/ + |