Library . Google . Spreadsheets . AddListRows

Adds one or more rows to a worksheet in a Google spreadsheet using a simple XML file you provide.

Input
• ClientID The Client ID provided by Google. Required unless providing a valid AccessToken.
• ClientSecret The Client Secret provided by Google. Required unless providing a valid AccessToken.
• RefreshToken An OAuth Refresh Token used to generate a new Access Token when the original token is expired. Required unless providing a valid AccessToken.
• RowsetXML The rows of data that you want to add to a worksheet in XML format. Your XML needs to be in the rowset/row schema described in the Choreo documentation.
• SpreadsheetKey The unique key of the spreadsheet that contains the worksheet you want to add rows to.
• WorksheetId The unique ID of the worksheet that you want to add rows to.
Optional Input
• AccessToken A valid Access Token retrieved during the OAuth process. This is required unless you provide the ClientID, ClientSecret, and RefreshToken to generate a new Access Token.
• ResponseFormat The format that the response should be in. Valid values are: xml (the default) and json.
Log In To Run
• Output
  Actuator Trigger Condition

  If{"NewAccessToken":{"type":"string","description":"Contains a new AccessToken when the RefreshToken is provided."},"Response":{"type":"","description":"The response from Google."},"Success":{"type":"boolean"}}NewAccessTok...ResponseSuccess then write

  High Low

  to at

  • NewAccessToken Contains a new AccessToken when the RefreshToken is provided.
  • Response The response from Google.
• CHOREO CLASS

  • /*
    TembooTask class placeholder
    */

• iOS HEADER

  • /*
    TembooTask header placeholder
    */

• • Simple
  Enhanced
  Add a sensor via the virtual pin board above to generate code for sensor data graphs.
  Compiled
  Add a sensor or actuator via the virtual pin board above to generate compiled code for sensor data graphs and remote actuator control.
  Device Configure Changed

  Since you've changed your device configuration, you'll need to tell us about this new device.

  Update Device
  1. Add a sensor or actuator to your device.
  2. Register your board and download your code.

  Download
  • Download editable code
  • Commit to GitHub
  • Send to CCS Cloud

  OK! Let's set up your device

  This feature is in experimental mode - pricing coming soon.

  Device Name *

  Device ID

  Description

  Location *

  Use lat/long

  Sensor Data
  Frequency *

  Pro Tip!

  Power consumption will increase if you choose a higher frequency.

  Every 30 seconds Every minute Every 5 minutes Every 30 minutes Every hour Every day Custom interval

  Safeguard data

  what's this?

  If connectivity is lost, up to 2MB of data will be stored locally on your device, and updated when connectivity is restored.

  + new tag

  Save
  Commit your generated code
  and collaborate with others.

  Send your code straight to a GitHub repository.

  Collaborating on GitHub?

  Your code will be visible by others in your repos. Keep credentials private by saving a Profile or commit code with Placeholder inputs.

  Choose a GitHub Repository

  Name:

  The following files will be added to this repo:

  * Don't worry! Your credentials and any inputs that aren't saved in a Profile will not be included.

  Success!

  Visit the link below to view, modify, and share code.

  Cancel Commit code to GitHub Use Placeholders Save a Profile Commit Close
  Send code to CCS Cloud.

  You'll be able to edit and share your code from TI's CCS Cloud IDE.

  Name your application

  Names can only contain letters, numbers, hyphens, and underscores.

  The following will be sent to CCS Cloud:

  TembooMain.c

  TembooAccount.h

  instructions.txt

  + 9 others

  Success!

  Visit the link below to view, modify, and share code.

  https://dev.ti.com/ide/

  Cancel Send to CCS Cloud Send Close
  Code

  • // Instantiate the Choreo, using a previously instantiated TembooSession object, eg:
    // TembooSession session = new TembooSession("accountName", "myFirstApp", "abc123xxxxxxxxxxxxxx");
    
    AddListRows addListRowsChoreo = new AddListRows(session);
    
    // Get an InputSet object for the choreo
    AddListRowsInputSet addListRowsInputs = addListRowsChoreo.newInputSet();
    
    // Set inputs
    
    // Execute Choreo
    AddListRowsResultSet addListRowsResults = addListRowsChoreo.execute(addListRowsInputs);

• Header File

  • /* 
    A header file containing your Temboo account information will appear here once you've
    configured your device above.
    */

• Proxy Code

  • /*
    Please log in to generate proxy server code for use with the JavaScript SDK.
    */

• Notes

  • This Choreo adds one or more rows to a worksheet 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>
      <row>
        <firstname>john</firstname>
        <lastname>smith</lastname>
        <email>john@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 and WorksheetId are required and can be retrieved using the RetrieveSpreadsheetDetailsByName Choreo.

    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
    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='&quot;H1hBIjt7Myt7ImA9CEACRkkN&quot;'>
      <id>https://spreadsheets.google.com/feeds/list/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/od4/c0p7u</id>
      <updated>2011-11-29T20:44:22.042Z</updated>
      <app:edited xmlns:app='http://www.w3.org/2007/app'>2011-11-29T20:44:22.042Z</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: stan@temboo.com</content>
      <link rel='self' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/od4/private/full/c0p7u'/>
      <link rel='edit' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/od4/private/full/c0p7u'/>
      <gsx:firstname>stan</gsx:firstname>
      <gsx:lastname>johnson</gsx:lastname>
      <gsx:email>stan@temboo.com</gsx:email>
    </entry>