Finally, you will run a configuration sketch to prepare your Yún for sending sensor data to Temboo.
If you're using a Yún: go to the File > Examples > Temboo > ArduinoYun menu and run the TembooDeviceConfig
sketch.
If you're using a Yún shield: go to the File > Examples > Temboo > YunShield menu and run the TembooDeviceConfig
sketch.
Use the dropdown menu at the top of the Choreo page to select as your platform.
The first step in monitoring sensor data is to set up the sensor you wish to monitor. We provide unit converted data for specific sensor models, such as Celsius and Fahrenheit for temperature sensors. We also support unconverted data which is reported as raw values for analog data and high/low for digital.
For this tutorial we're going to read temperature data from a Texas Instruments LMT84P. Our unit conversion formula assumes that your temperature sensor is connected to your 's 5V pin for its voltage in, and set up as specified in the sensor's data sheet.
Using the virtual pin board on the Choreo page, select pin to set up your sensor. Select the category Temperature, then choose the Texas Instruments LMT84LP.
Each time you set up a sensor you'll be asked to specify the safe bounds and the caution bounds. These bounds are used to determine the color coding of the data that appears on your graph. Safe data is colored green and data near the bounds is orange. Data outside the bounds is red.
Set the safe bounds as 40º and 45º, and the caution bounds as 5º. That's all we need to do to set up our sensor, so press Save.
We will focus only on getting sensor data graphs running, so set a condition based on your sensor so that it doesn't trigger the email. Use the conditions interface to set a condition that will always be false so we don't send any emails.
Next, we'll generate the code that will send our sensor data to Temboo. Scroll down and find the code box. Click the triangle next to Simple Code to open the code menu, and choose Enhanced Code.
Now you will register your device. To do so, name your device and, optionally, give it a description. Specify the device location—this will allow you to view your devices on a map. For testing purposes, it's good to set a relatively short sensor interval so that you can see sensor data populate your graphs quickly. You can use the custom interval option for this. Press Save when you're done.
In order to run this sketch, it needs to be configured with an appropriate TembooAccount.h
header file containing your Temboo account information. Header files for certain boards will also include the device’s internet connection details.
To create the header file, make a new tab in the IDE, and name it TembooAccount.h
.
TembooAccount.h
tab in your IDE.Now that your code is running, open a new browser window to head over to your Devices page to see it in action. A virtual representation of your device will be waiting for you.
Select your new device and you'll see a sensor data graph for the sensor that you set up. Over time, you'll be able to see sensor data graphs for various time periods. Additionally, at any time, you can request the latest value of your sensors. This is a handy feature for when you're between sensor intervals but want to know what's happening on your device.
We're always happy to help. Just email us at support@temboo.com, and we'll answer your questions.
Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.
https://ACCOUNT_NAME.temboolive.com/callback/google
Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets
. Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).
Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.
Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.
Select from the drop down menu at the top of the page.
We are logging sensor readings, so we need to set up a sensor. For this tutorial we're going to read temperature data from a Texas Instruments LMT84P.
Using the virtual pin board on the Choreo page, select pin to set up your sensor. Select the category 'Temperature', and name your sensor.
Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.
The Values input should be formatted in JSON as an array of arrays.
[ [ "100", "200", "300" ] ]
To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:
[ [ "100", "200", "300" ], [ "400", "500", "600" ] ]
Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.
To dynamically insert sensor values into your Values JSON, use the blue sensor icon in the corner of the Values input field. Take care when inserting dynamic values into JSON.
In order to run this sketch, it needs to be configured with an appropriate TembooAccount.h
header file containing your Temboo account information. Header files for certain boards will also include the device’s internet connection details.
To create the header file, make a new tab in the IDE, and name it TembooAccount.h
.
TembooAccount.h
tab in your IDE.Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.
See the Google Sheets documentation for more information about formatting your chart.
Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.
We're always happy to help. Just email us at support@temboo.com, and we'll answer your questions.
If this is your first time using Temboo, you'll need to set up your ARTIK board to find the Temboo libraries. To do so, you'll need to create the file temboo.conf
in /etc/ld.so.conf.d
. Inside of temboo.conf
, you'll want to copy the line below and paste it into the file:
/opt/iothub/artik/temboo/temboo_artik_library/lib
temboo.conf
, run ldconfig
from the command line to add the Temboo library directory to the system library search path.You’ll also need to get the IP address of your ARTIK board using ifconfig
. The example below shows the results when the ARTIK board is connected to the internet through an ethernet cable. The IP address you'll want to use is listed next to inet.
[root@localhost ~]$ ifconfig eth0: flags=4163mtu 1500 inet 10.11.6.200 netmask 255.255.255.0 broadcast 10.11.6.255
Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.
https://ACCOUNT_NAME.temboolive.com/callback/google
Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets
. Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).
Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.
Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.
Select from the drop down menu at the top of the page.
We are logging sensor readings, so we need to set up a sensor. For this tutorial we're going to read temperature data from a Texas Instruments LMT84P.
Using the virtual pin board on the Choreo page, select pin to set up your sensor. Select the category 'Temperature', and name your sensor.
Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.
The Values input should be formatted in JSON as an array of arrays.
[ [ "100", "200", "300" ] ]
To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:
[ [ "100", "200", "300" ], [ "400", "500", "600" ] ]
Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.
To dynamically insert sensor values into your Values JSON, use the blue sensor icon in the corner of the Values input field. Take care when inserting dynamic values into JSON.
Download the generated code to your computer by clicking Download source code to the right of the code.
Copy the downloaded zip file to your ARTIK board using scp
. From your computer, go to the directory where the zip file is located and type the command below. Make sure you use the IP address for your board you found using ifconfig
.
[root@localhost ~]$ scp .zip root@xxx.xxx.xxx.xxx:/home
From the ARTIK command line (either through a serial terminal or ssh session), change your current directory to /home
. Next, unzip the generated code you just copied over. You can unzip the file by using the command below:
[root@localhost ~]$ unzip .zip
Now go to the directory and compile and run your code using the commands below. Run the first command to compile your code. After compiling has finished and no errors have been reported, run your program using the second command. After running the program, you should see the response from in your console.
[root@localhost ~]$ gcc -L/opt/iothub/artik/temboo/temboo_artik_library/lib -ltemboo -I/opt/iothub/artik/temboo/temboo_artik_library/include s.c -o [root@localhost ~]$ ./
Note: If you get an error about cdefs.h not being found, this could mean your ARTIK board was not shipped with glibc-headers. This can be solved by reinstalling glibc-headers using the command below. After reinstalling glibc-headers, run the two commands above to compile and run your code.
[root@localhost ~]$ yum reinstall glibc-headers
Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.
See the Google Sheets documentation for more information about formatting your chart.
Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.
We're always happy to help. Just email us at support@temboo.com, and we'll answer your questions.
Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.
https://ACCOUNT_NAME.temboolive.com/callback/google
Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets
. Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).
Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.
Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.
Select from the drop down menu at the top of the page.
We are logging sensor readings, so we need to set up a sensor. For this tutorial we're going to read temperature data from a Texas Instruments LMT84P.
Using the virtual pin board on the Choreo page, select pin to set up your sensor. Select the category 'Temperature', and name your sensor.
Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.
The Values input should be formatted in JSON as an array of arrays.
[ [ "100", "200", "300" ] ]
To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:
[ [ "100", "200", "300" ], [ "400", "500", "600" ] ]
Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.
To dynamically insert sensor values into your Values JSON, use the blue sensor icon in the corner of the Values input field. Take care when inserting dynamic values into JSON.
In order to run this sketch, it needs to be configured with an appropriate TembooAccount.h
header file containing your Temboo account information. Header files for certain boards will also include the device’s internet connection details.
To create the header file, make a new tab in the IDE, and name it TembooAccount.h
.
TembooAccount.h
tab in your IDE.The final step before running any sketch is to confirm that you've selected the appropriate board and serial port in Energia. Go to the Tools > Board menu and select the LaunchPad you're working with. Then go to Tools > Serial Port and select the port your board is connected to.
Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.
See the Google Sheets documentation for more information about formatting your chart.
Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.
We're always happy to help. Just email us at support@temboo.com, and we'll answer your questions.
Use the dropdown menu at the top of the Choreo page to select as your platform.
The first step in monitoring sensor data is to set up the sensor you wish to monitor. We provide unit converted data for specific sensor models, such as Celsius and Fahrenheit for temperature sensors. We also support unconverted data which is reported as raw values for analog data and high/low for digital.
For this tutorial we're going to read temperature data from a Texas Instruments LMT84P. Our unit conversion formula assumes that your temperature sensor is connected to your 's 5V pin for its voltage in, and set up as specified in the sensor's data sheet.
Using the virtual pin board on the Choreo page, select pin to set up your sensor. Select the category Temperature, then choose the Texas Instruments LMT84LP.
Each time you set up a sensor you'll be asked to specify the safe bounds and the caution bounds. These bounds are used to determine the color coding of the data that appears on your graph. Safe data is colored green and data near the bounds is orange. Data outside the bounds is red.
Set the safe bounds as 40º and 45º, and the caution bounds as 5º. That's all we need to do to set up our sensor, so press Save.
We will focus only on getting sensor data graphs running, so set a condition based on your sensor so that it doesn't trigger the email. Use the conditions interface to set a condition that will always be false so we don't send any emails.
Next, we'll generate the code that will send our sensor data to Temboo. Scroll down and find the code box. Click the triangle next to Simple Code to open the code menu, and choose Enhanced Code.
Now you will register your device. To do so, name your device and, optionally, give it a description. Specify the device location—this will allow you to view your devices on a map. For testing purposes, it's good to set a relatively short sensor interval so that you can see sensor data populate your graphs quickly. You can use the custom interval option for this. Press Save when you're done.
Scroll down to the code box of the Choreo page. Click Send to CCS Cloud to the right of your generated code. Name your application and click Send. Click the link that appears to visit the CCS Cloud IDE in your browser.
Run the code on your CC3220 from CCS Cloud. After running the code, open the Serial Monitor and you'll see the response from the Choreo.
Now that your code is running, open a new browser window to head over to your Devices page to see it in action. A virtual representation of your device will be waiting for you.
Select your new device and you'll see a sensor data graph for the sensor that you set up. Over time, you'll be able to see sensor data graphs for various time periods. Additionally, at any time, you can request the latest value of your sensors. This is a handy feature for when you're between sensor intervals but want to know what's happening on your device.
We're always happy to help. Just email us at support@temboo.com, and we'll answer your questions.
.jar
file (e.g. temboo-android-sdk-core-2.19.0.jar
) in the Temboo SDK folder you just downloaded and extracted.libs
folder of your projectYou've now added the core Temboo SDK to your project. Repeat the above steps to add the application bundle (e.g. -2.19.0.jar
) from the Temboo SDK folder you just extracted, which will allow us to use APIs.
We'll now make some adjustments to the default application that Android Studio has generated for us.
app/src/main/res/AndroidManifest.xml
. In order to access the internet, you will need to add <uses-permission android:name="android.permission.INTERNET"/>
below the <application>
tag.TextView
that we'll make use of, but before we can do so we need to give it an identifier. Locate and double-click on the fileapp > src > main > res > layout > activity_main.xml
. This file describes the layout of our MainActivity
class.TextView
.@+id/response
Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.
https://ACCOUNT_NAME.temboolive.com/callback/google
Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets
. Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).
Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.
Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.
Select from the drop down menu at the top of the page.
Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.
The Values input should be formatted in JSON as an array of arrays.
[ [ "100", "200", "300" ] ]
To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:
[ [ "100", "200", "300" ], [ "400", "500", "600" ] ]
Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.
Because network operations block the main thread execution, we'll need to make our calls to Temboo using AsyncTask
. Create a new class that extends AsyncTask
called SheetsTask
(or whatever you like), adding the @Override
implementations for doInBackground
and onProcessComplete
:
package com.temboo.android.gettingstarted.app; import android.os.AsyncTask; import android.util.Log; import android.widget.TextView; /** * An AsyncTask that will be used to interact with Temboo */ class SheetsTask extends AsyncTask<Void, Void, String> { private TextView textView; public SheetsTask(TextView textView){ this.textView = textView; } @Override protected String doInBackground(Void... arg0) { try { // Temboo code will go here } catch(Exception e) { // if an exception occurred, log it Log.e(this.getClass().toString(), e.getMessage()); } return null; } protected void onPostExecute(String result) { try { // Will update UI here } catch(Exception e) { // if an exception occurred, show an error message Log.e(this.getClass().toString(), e.getMessage()); } } }
TextView
as an argument. This will reference the TextView
we set up earlier.Now that our AsyncTask
is set up, copy the generated code snippet from the Temboo website and paste it into the doInBackground
method of your AsyncTask
class. We'll also add the required imports to create a AppendValues
Choreo, AppendValuesInputSet
, and AppendValuesResultSet
:
import com.temboo.Library.Google.Sheets.AppendValues; import com.temboo.Library.Google.Sheets.AppendValues.AppendValuesInputSet; import com.temboo.Library.Google.Sheets.AppendValues.AppendValuesResultSet; import com.temboo.core.TembooSession;
Each Choreo in the Android SDK returns a ResultSet
subclass that contains get methods tailored specifically to the outputs of that Choreo. Using the ResultSet
, you can retrieve the raw data (typically XML or JSON) returned by a third-party API or relevant fields that we've parsed out of the response for you.
To update the UI with the API response returned by the Choreo, do the following:
Add the following code at the bottom of the try
block of the doInBackground
method in your class:
return appendValues.get_Response() ;
The return value we've just added is passed by Android as an argument to the onPostExecute
method, we'll update the UI there:
protected void onPostExecute(String result) { try { // Update the UI textView.setText(result); } catch(Exception e) { // if an exception occurred, show an error message Log.e(this.getClass().toString(), e.getMessage()); } }
In order to see your new task in action, you will need to invoke it from the MainActivity
class created with your project. The simplest way to do this is to add a call to it in the onCreate
method, which should end up looking like this:
@Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); TextView textView = (TextView) findViewById(R.id.response); new SheetsTask(textView).execute(); }
In order to post dynamic values to your sheet from your Android application, you'll need to build a String object to pass as input to the AppendValues Choreo. Create a String object containing properly formatted JSON in your code that includes any variables you wish to post to your sheet and name it customValueSet
or whatever you like, then pass it to appendValuesInputs.set_Values()
like so:
appendValuesInputs.set_Values(customValueSet);
Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.
See the Google Sheets documentation for more information about formatting your chart.
Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.
We're always happy to help. Just email us at support@temboo.com, and we'll answer your questions.
TembooTest
. The new project should automatically include a C# class file called Program.cs
containing a Main
method.References
folder under TembooTest
and select Add Reference. In the dialogue box that appears, click Browse and select TembooSDK.dll
located in the bin
folder within the extracted Temboo SDK directory. Click OK.Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.
https://ACCOUNT_NAME.temboolive.com/callback/google
Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets
. Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).
Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.
Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.
Select from the drop down menu at the top of the page.
Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.
The Values input should be formatted in JSON as an array of arrays.
[ [ "100", "200", "300" ] ]
To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:
[ [ "100", "200", "300" ], [ "400", "500", "600" ] ]
Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.
Program.cs
with the copied code.In order to post dynamic values to your sheet from your C# application, you'll need to build a JSON string to pass as input to the AppendValues Choreo. Create a properly formatted JSON string in your code that includes any variables you wish to post to your sheet and name it customValueSet
or whatever you like, then edit appendValuesChoreo.setValues()
, passing in customValueSet
like so:
appendValuesChoreo.setValues(customValueSet);
Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.
See the Google Sheets documentation for more information about formatting your chart.
Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.
We're always happy to help. Just email us at support@temboo.com, and we'll answer your questions.
TembooTest
, select Objective-C as the Language, and click Next (the other fields are optional and may be left blank) to save your new project.TembooTest
and contain a file called main.m
), then select Add Files to TembooTest from the File menu. Browse to where you saved the Temboo SDK, locate and click on the core
folder inside the SDK src
folder. Make sure that Copy items if needed is unchecked and Create groups is selected, and then click Add.TMB.h
and TMB.m
files located in the SDk's src/library
folder.Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.
https://ACCOUNT_NAME.temboolive.com/callback/google
Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets
. Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).
Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.
Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.
Select from the drop down menu at the top of the page.
Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.
The Values input should be formatted in JSON as an array of arrays.
[ [ "100", "200", "300" ] ]
To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:
[ [ "100", "200", "300" ], [ "400", "500", "600" ] ]
Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.
main.m
file, below the import statement for <Foundation/Foundation.h>
and above the main
method. Finally, update the main
method in main.m
with the code below so that your file calls the AppendValues Choreo:
int main(int argc, const char * argv[]) { @autoreleasepool { // Create a new instance of our class AppendValues *tutorial = [[AppendValues alloc] init]; // Run it [tutorial runAppendValuesChoreo]; // Only needed for command line tools, this simply keeps the program from exiting immediately [[NSRunLoop currentRunLoop] run]; } return 0; }
In order to post dynamic values to your sheet from your iOS application, you'll need to build a JSON string to pass as input to the AppendValues Choreo. Create a properly formatted JSON string in your code that includes any variables you wish to post to your sheet and name it customValueSet
or whatever you like, then edit appendValuesInputs setValues
, passing in customValueSet
like so:
[appendValuesInputs setValues:customValueSet];
Each Choreo in the iOS SDK returns a ResultSet
subclass that contains get methods tailored specifically to the outputs of that Choreo. Using the ResultSet
, you can retrieve the raw data (typically XML or JSON) returned by a third-party API or relevant fields that we've parsed out of the response for you. Our snippets include code to print out the results returned by the Choreo in question.
Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.
See the Google Sheets documentation for more information about formatting your chart.
Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.
We're always happy to help. Just email us at support@temboo.com, and we'll answer your questions.
/libs
./libs
folder. Refresh the project, then right-click the JAR file and select: Build Path > Add to Build Path.main
method to your project. You can call it whatever you like.Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.
https://ACCOUNT_NAME.temboolive.com/callback/google
Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets
. Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).
Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.
Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.
Select from the drop down menu at the top of the page.
Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.
The Values input should be formatted in JSON as an array of arrays.
[ [ "100", "200", "300" ] ]
To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:
[ [ "100", "200", "300" ], [ "400", "500", "600" ] ]
Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.
main
method of your Java class. Press Cmd+Shift+O
(or Ctrl+Shift+O
in Windows) to automatically import dependencies. Note: your main method should declare that it throws Exception
.In order to post dynamic values to your sheet from your Java application, you'll need to build a JSON string to pass as input to the AppendValues Choreo. Create a properly formatted JSON string in your code that includes any variables you wish to post to your sheet and name it customValueSet
or whatever you like, then edit appendValuesInputs.set_Values()
, passing in customValueSet
like so:
appendValuesInputs.set_Values(customValueSet);
Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.
See the Google Sheets documentation for more information about formatting your chart.
Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.
We're always happy to help. Just email us at support@temboo.com, and we'll answer your questions.
.html
file and save it as temboo-example.html
into a folder where you'll save the rest of your project files..php
file and save it as proxy-server.php
into the same project folder as your temboo-example.html
file.js-sdk
and move it into the same folder as your temboo-example.html
file.Change the name of the resulting folder to php-sdk
and move it into the same folder as your temboo-example.html
file. Your project folder should look similar to the screenshot below:
Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.
https://ACCOUNT_NAME.temboolive.com/callback/google
Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets
. Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).
Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.
Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.
Select from the drop down menu at the top of the page.
Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.
The Values input should be formatted in JSON as an array of arrays.
[ [ "100", "200", "300" ] ]
To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:
[ [ "100", "200", "300" ], [ "400", "500", "600" ] ]
Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.
temboo-example.html
file.In your temboo-example.html
file, make sure that your script source points to the correct location of the temboo.js
SDK file.
<script src="js-sdk/js/temboo.js"></script>
In the same file, we'll also want to confirm that the location of our proxy is correctly specified. Our server is proxy-server.php
.
// Instantiate the client proxy with the URI of your server proxy var temboo = new TembooProxy('proxy-server.php');
Back on the Choreo page, scroll down to the Proxy Code snippet and select PHP or another server-side proxy language from the Proxy Code Language dropdown menu. Copy the proxy code snippet and paste it into your proxy-server.php
file.
In the same .php
file, make sure that the php-sdk
SDK folder that you downloaded earlier.
require 'php-sdk/src/temboo.php';
In order to post dynamic values to your sheet from your web application, you'll need to build a JSON string to pass as input to the AppendValues Choreo. Create a properly formatted JSON string in your code that includes any variables you wish to post to your sheet and name it customValueSet
or whatever you like, then edit appendValuesChoreo.setInput()
, passing in customValueSet
like so:
appendValuesChoreo.setInput('Values', customValueSet);
Run the PHP server. For instance, if you're running the code using a web host, you can upload your project folder to your site via FTP client. If you're using Apache for PHP to run a local server, you'd run the following command from Terminal:
sudo apachectl start
Go to temboo-example.html
in the browser at the url where you're server is running. For instance, if you're running the PHP server locally:
127.0.0.1/projectFolderName/temboo-example.html
Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.
See the Google Sheets documentation for more information about formatting your chart.
Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.
We're always happy to help. Just email us at support@temboo.com, and we'll answer your questions.
tembootest.js
, though you can call it whatever you like.node_modules
in accordance with the convention established by the Node Package Manager. Move the node_modules
folder to the same directory as your new .js project file.Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.
https://ACCOUNT_NAME.temboolive.com/callback/google
Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets
. Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).
Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.
Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.
Select from the drop down menu at the top of the page.
Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.
The Values input should be formatted in JSON as an array of arrays.
[ [ "100", "200", "300" ] ]
To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:
[ [ "100", "200", "300" ], [ "400", "500", "600" ] ]
Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.
Make sure that all of your import statements are included. Both of the following lines should be present and uncommented in your code.
var tsession = require("temboo/core/temboosession"); var Google = require("temboo/Library/Google/Sheets");
In order to post dynamic values to your sheet from your Node.js application, you'll need to build a JSON string to pass as input to the AppendValues Choreo. Create a properly formatted JSON string in your code that includes any variables you wish to post to your sheet and name it customValueSet
or whatever you like, then edit appendValuesInputs.set_Values()
, passing in customValueSet
like so:
appendValuesInputs.set_Values(customValueSet);
Now you're ready to run the script to post values to Google Sheets. Here's the command you need to run if you're executing this from the command line. Otherwise just run it from your IDE.
node tembootest.js
Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.
See the Google Sheets documentation for more information about formatting your chart.
Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.
We're always happy to help. Just email us at support@temboo.com, and we'll answer your questions.
Unzip the downloaded SDK and move the resulting php-sdk folder into the same parent folder as your new, blank PHP file.
Add the Temboo PHP SDK to your script:
require 'php-sdk/src/temboo.php';
Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.
https://ACCOUNT_NAME.temboolive.com/callback/google
Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets
. Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).
Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.
Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.
Select from the drop down menu at the top of the page.
Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.
The Values input should be formatted in JSON as an array of arrays.
[ [ "100", "200", "300" ] ]
To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:
[ [ "100", "200", "300" ], [ "400", "500", "600" ] ]
Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.
In order to post dynamic values to your sheet from your PHP application, you'll need to build a JSON string to pass as input to the AppendValues Choreo. Create a properly formatted JSON string in your code that includes any variables you wish to post to your sheet and name it customValueSet
or whatever you like, then edit $appendValuesInputs->setValues()
, passing in customValueSet
like so:
$appendValuesInputs->setValues($customValueSet);
Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.
See the Google Sheets documentation for more information about formatting your chart.
Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.
We're always happy to help. Just email us at support@temboo.com, and we'll answer your questions.
temboo
folder into your Documents/Processing/libraries/
folder (or My Documents/Processing/libraries/
on a PC). If Processing is currently open, restart it so that it will recognize the Temboo library that you just added.Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.
https://ACCOUNT_NAME.temboolive.com/callback/google
Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets
. Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).
Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.
Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.
Select from the drop down menu at the top of the page.
Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.
The Values input should be formatted in JSON as an array of arrays.
[ [ "100", "200", "300" ] ]
To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:
[ [ "100", "200", "300" ], [ "400", "500", "600" ] ]
Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.
In order to run this sketch, your Temboo account name and application details must be included in the TembooSession
, like so:
When you're logged in, this information is automatically populated in your generated sketch. Remember to remove your account details if you share your sketch.
In order to post dynamic values to your sheet from your Processing sketch, you'll need to build a JSON string to pass as input to the AppendValues Choreo. Create a properly formatted JSON string in your code that includes any variables you wish to post to your sheet and name it customValueSet
or whatever you like, then edit appendValuesChoreo.setValues()
, passing in customValueSet
like so:
appendValuesChoreo.setValues(customValueSet);
Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.
See the Google Sheets documentation for more information about formatting your chart.
Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.
We're always happy to help. Just email us at support@temboo.com, and we'll answer your questions.
TembooTest.py
, though you can call it whatever you like.Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.
https://ACCOUNT_NAME.temboolive.com/callback/google
Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets
. Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).
Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.
Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.
Select from the drop down menu at the top of the page.
Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.
The Values input should be formatted in JSON as an array of arrays.
[ [ "100", "200", "300" ] ]
To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:
[ [ "100", "200", "300" ], [ "400", "500", "600" ] ]
Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.
TembooTest.py
file.In order to post dynamic values to your sheet from your Python script, you'll need to build a JSON string to pass as input to the AppendValues Choreo. Create a properly formatted JSON string in your code that includes any variables you wish to post to your sheet and name it custom_value_set
or whatever you like, then edit appendValuesInputs.set_Values()
, passing in custom_value_set
like so:
appendValuesInputs.set_Values(custom_value_set)
Now you're ready to run the script and post the data to your Google Sheet. Here's the command you need to run if you're executing this from the command line. Otherwise just run it from your IDE.
python TembooTest.py
Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.
See the Google Sheets documentation for more information about formatting your chart.
Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.
We're always happy to help. Just email us at support@temboo.com, and we'll answer your questions.
gem install temboo-ruby-sdk-x.gem
, where x is the version number. You will now be able to access Temboo's Ruby SDK in your code.Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.
https://ACCOUNT_NAME.temboolive.com/callback/google
Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets
. Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).
Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.
Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.
Select from the drop down menu at the top of the page.
Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.
The Values input should be formatted in JSON as an array of arrays.
[ [ "100", "200", "300" ] ]
To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:
[ [ "100", "200", "300" ], [ "400", "500", "600" ] ]
Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.
Make sure your imports are in place at the top of the file. They should look like the sample below.
require "temboo" require "Library/Google"
In order to post dynamic values to your Sheet from your Ruby application, you'll need to build a JSON string to pass as input to the AppendValues Choreo. Create a properly formatted JSON string in your code that includes any variables you wish to post to your sheet and name it customValueSet
or whatever you like, then edit appendValuesInputs.set_Values()
, passing in customValueSet
like so:
appendValuesInputs.set_Values(customValueSet);
Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.
See the Google Sheets documentation for more information about formatting your chart.
Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.
We're always happy to help. Just email us at support@temboo.com, and we'll answer your questions.
Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.
https://ACCOUNT_NAME.temboolive.com/callback/google
Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets
. Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).
Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.
Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.
Select from the drop down menu at the top of the page.
Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.
The Values input should be formatted in JSON as an array of arrays.
[ [ "100", "200", "300" ] ]
To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:
[ [ "100", "200", "300" ], [ "400", "500", "600" ] ]
Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.
Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.
See the Google Sheets documentation for more information about formatting your chart.
Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.
We're always happy to help. Just email us at support@temboo.com, and we'll answer your questions.