diff options
Diffstat (limited to 'libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet')
| -rw-r--r-- | libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet/SendDataToGoogleSpreadsheet.ino | 178 | ||||
| -rw-r--r-- | libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet/TembooAccount.h | 5 | 
2 files changed, 0 insertions, 183 deletions
| diff --git a/libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet/SendDataToGoogleSpreadsheet.ino b/libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet/SendDataToGoogleSpreadsheet.ino deleted file mode 100644 index 1f1b6b4..0000000 --- a/libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet/SendDataToGoogleSpreadsheet.ino +++ /dev/null @@ -1,178 +0,0 @@ -/* -  SendDataToGoogleSpreadsheet - -  Demonstrates appending a row of data to a Google spreadsheet using Temboo from an Arduino Yun. - -  Check out the latest Arduino & Temboo examples and support docs at http://www.temboo.com/arduino - -  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 - -  Since this sketch uses a Google spreadsheet, you'll also need a  -  Google account: substitute the placeholders below for your Google account values. - -  This example assumes basic familiarity with Arduino sketches, and that your  -  Yun is connected to the Internet. - -  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. -  In other words, your spreadsheet should look like: -   -  Time  |  Sensor Value  |      -  ------+----------------- -        |                | -   -  NOTE that the first time you run this sketch, you may receive a warning from -  Google, prompting you to authorize access from a 3rd party system. -   -  Looking for another API to use with your Arduino Yun? We've got over 100 in our Library! - -  This example code is in the public domain. - -*/ - -#include <Bridge.h> -#include <Temboo.h> -#include "TembooAccount.h" // contains Temboo account information,  -                           // as described in the footer comment below - - -/*** SUBSTITUTE YOUR VALUES BELOW: ***/ - -// Note that for additional security and reusability, you could -// use #define statements to specify these values in a .h file. - -const String GOOGLE_USERNAME = "your-google-username"; -const String GOOGLE_PASSWORD = "your-google-password"; - -// the title of the spreadsheet you want to send data to -// (Note that this must actually be the title of a Google spreadsheet -// that exists in your Google Drive/Docs account, and is configured -// as described above.) -const String SPREADSHEET_TITLE = "your-spreadsheet-title"; - -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 -    TembooChoreo AppendRowChoreo; - -    // invoke the Temboo client -    // NOTE that the client must be reinvoked and repopulated with -    // appropriate arguments each time its run() method is called. -    AppendRowChoreo.begin(); -     -    // set Temboo account credentials -    AppendRowChoreo.setAccountName(TEMBOO_ACCOUNT); -    AppendRowChoreo.setAppKeyName(TEMBOO_APP_KEY_NAME); -    AppendRowChoreo.setAppKey(TEMBOO_APP_KEY); -     -    // identify the Temboo Library choreo to run (Google > Spreadsheets > AppendRow) -    AppendRowChoreo.setChoreo("/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) -    AppendRowChoreo.addInput("Username", GOOGLE_USERNAME); - -    // your Google account password -    AppendRowChoreo.addInput("Password", GOOGLE_PASSWORD); - -    // the title of the spreadsheet you want to append to -    // NOTE: substitute your own value, retaining the "SpreadsheetTitle:" prefix. -    AppendRowChoreo.addInput("SpreadsheetTitle", 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.addInput("RowData", rowData); - -    // run the Choreo and wait for the results -    // The return code (returnCode) will indicate success or failure  -    unsigned int returnCode = AppendRowChoreo.run(); - -    // return code of zero (0) means success -    if (returnCode == 0) { -      Serial.println("Success! Appended " + rowData); -      Serial.println(""); -    } else { -      // return code of anything other than zero means failure   -      // read and display any error messages -      while (AppendRowChoreo.available()) { -        char c = AppendRowChoreo.read(); -        Serial.print(c); -      } -    } - -    AppendRowChoreo.close(); -  } -} - -// this function simulates reading the value of a sensor  -unsigned long getSensorValue() { -  return analogRead(A0); -} - -/* -  IMPORTANT NOTE: TembooAccount.h: - -  TembooAccount.h is a file referenced by this sketch that contains your Temboo account information. -  You'll need to edit the placeholder version of TembooAccount.h included with this example sketch, -  by inserting your own Temboo account name and app key information. The contents of the file should -  look like: - -  #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 - -  You can find your Temboo App Key information on the Temboo website,  -  under My Account > Application Keys - -  The same TembooAccount.h file settings can be used for all Temboo SDK sketches. - -  Keeping your account information in a separate file means you can share the main .ino file without worrying  -  that you forgot to delete your credentials. -*/ diff --git a/libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet/TembooAccount.h b/libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet/TembooAccount.h deleted file mode 100644 index 8d7dcfb..0000000 --- a/libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet/TembooAccount.h +++ /dev/null @@ -1,5 +0,0 @@ -#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 - - | 
