aboutsummaryrefslogtreecommitdiff
path: root/libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet
diff options
context:
space:
mode:
authorCristian Maglie <c.maglie@bug.st>2013-06-27 22:40:34 +0200
committerCristian Maglie <c.maglie@bug.st>2013-06-27 22:40:34 +0200
commitf34eaf039af4f442f4adf0ddb80e53a6cdaa5c2f (patch)
treec8cdb13fd419d4682f6a94f5145afc5ba7ad9dd4 /libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet
parentab4e82ddb038d8826d761c6ff5c9f08f63928cbd (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.ino165
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!)
+*/
+