You have no favorites... yet!
Use the Library tree on the left to select a Choreo to call from your gateway device.
Use the Library tree on the left to select a Choreo to call from your edge device via the gateway.
Library . Google . Spreadsheets . UpdateListRows
Updates a worksheet row in a Google spreadsheet using a simple XML file you provide.
/*
TembooTask class placeholder
*/
/*
TembooTask header placeholder
*/
Since you've changed your device configuration, you'll need to tell us about this new device.
This feature is in experimental mode - pricing coming soon.
Send your code straight to a GitHub repository.
Your code will be visible by others in your repos. Keep credentials private by saving a Profile or commit code with Placeholder inputs.
The following files will be added to this repo:
You'll be able to edit and share your code from TI's CCS Cloud IDE.
The following will be sent to CCS Cloud:
/*
Your auto-generated code will appear here once you've configured your device above.
*/
/*
A header file containing your Temboo account information will appear here once you've
configured your device above.
*/
/*
Please log in to generate proxy server code for use with the JavaScript SDK.
*/
This Choreo updates a worksheet row in a Google spreadsheet using a simple XML file you provide. The XML you submit to the Choreo must be in the following schema:
<rowset> <row> <firstname>stan</firstname> <lastname>johnson</lastname> <email>stan@temboo.com</email> </row> </rowset>
The column names above are just examples. You can have as many columns as you want, but they must correspond exactly to existing column names in your Google worksheet. Note that since column names exist as XML element names in a Google feed, characters that result in invalid XML element names are converted to a valid naming convention in the feed. For this reason, the column names that you provide in the RowsetXML should follow this convention too. For example, if your column name is "First Name", the column name in the RowsetXML that you provide should be: <FirstName></FirstName> or <firstname></firstname> (column names with upper-case letters are converted to lower-case in a Google feed, but you can use upper-case in the RowsetXML if you want). Any character that is not legal in XML element names (such as a space or ampersand) should be removed.
The SpreadsheetKey, WorksheetId, and RowId are required and can be retrieved using the RetrieveListFeed Choreo. You can either pass the individual values for these parameters or you can provide the full resource URL using the Link parameter. This can be a more convenient option if you're parsing the response from the RetrieveListFeed Choreo.
The Link for a particular row will look something like this:
https://spreadsheets.google.com/feeds/list/0ArNdNVaZJYRqdGJiZ3M3MEE2ZU42NUlLcFlOTHdlN1E/od6/private/full/ckd7g
In the link example above, the SpreadsheetKey is 0ArNdNVaZJYRqdGJiZ3M3MEE2ZU42NUlLcFlOTHdlN1E, the WorksheetId is od6, and the RowId is ckd7g. Passing these individual values to corresponding Choreo input variables is also allowed.
The documentation for this Google Spreadsheets resource can be found here.
Here is an example of acceptable inputs:
ClientID: {YOUR CLIENT ID}
ClientSecret: {YOUR CLIENT SECRET}
RefreshToken: {YOUR REFRESH TOKEN}
SpreadsheetKey: 0ArNdNVaZJYRqdGJiZ3M3MEE2ZU42NUlLcFlOTHdlN1E
WorksheetId: od6
RowId: ckd7g
RowsetXML:
<rowset> <row> <firstname>stan</firstname> <lastname>johnson</lastname> <email>stan@temboo.com</email> </row> </rowset>
The following is a sample of the XML information returned by this Choreo:
<?xml version='1.0' encoding='UTF-8'?> <entry xmlns='http://www.w3.org/2005/Atom' xmlns:gsx='http://schemas.google.com/spreadsheets/2006/extended' xmlns:gd='http://schemas.google.com/g/2005' gd:etag='"FAIaIj5xZit7ImA-WxUCFE1K"'> <id>https://spreadsheets.google.com/feeds/list/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/od4/bwhin</id> <updated>2011-11-29T23:08:10.550Z</updated> <app:edited xmlns:app='http://www.w3.org/2007/app'>2011-11-29T23:08:10.550Z</app:edited> <category scheme='http://schemas.google.com/spreadsheets/2006' term='http://schemas.google.com/spreadsheets/2006#list'/> <title>stan</title> <content>lastname: johnson, email: nice@temboo.com</content> <link rel='self' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/od4/private/full/bwhin'/> <link rel='edit' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/od4/private/full/bwhin'/> <gsx:firstname>stan</gsx:firstname> <gsx:lastname>johnson</gsx:lastname> <gsx:email>stan@temboo.com</gsx:email> </entry>
https://ACCOUNT_NAME.temboolive.com/callback/google
© 2025 Temboo, Inc Privacy Terms