Code Generation for APIs
Program the world. Generate code in less than 10 minutes.
This feature isn't available on your account.
Want to account?
Back to Kosmos

Choreos

Public
Private

You have no favorites... yet!

Your Private APIs Here

Enable digital transformation at your organization.

Learn More
  • 0
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • A5
  • A4
  • A3
  • A2
  • A1
  • A0
Get started with Arduino
Arduino
Arduino
Texas Instruments
Samsung
C#
Java
JavaScript
Node.js
PHP
Processing
Python
REST API
Ruby
iOS
Android
What's your device?
How is it connected?

Library . Google . Spreadsheets . StructuredQuery

Retrieves a list-based feed containing data in your Google spreadsheet that meets a specified criteria.

  • 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.
    • Query A valid structured query (i.e. id>4).
    • SpreadsheetKey The unique key of the spreadsheet associated with the feed you want to retrieve.
    • WorksheetId The unique ID of the worksheet associated with the feed you want to retrieve.
  • Optional Input
  • Output
    • NewAccessToken Contains a new AccessToken when the RefreshToken is provided.
    • Response The response from Google.
    • 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.

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

    OK! Let's set up your device

    This feature is in experimental mode - pricing coming soon.

    Use lat/long
    Pro Tip!
    Power consumption will increase if you choose a higher frequency.
    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.

    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.

    Commit code to GitHub

    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/
    Code 
    • /*
Your auto-generated code will appear here once you've configured your device above.
*/
  • Header File 
    • /* 
A header file containing your Temboo account information will appear here once you've
configured your device above.
*/
  • Notes

    • This Choreo retrieves a list-based feed containing data in your Google spreadsheet that meets a specified criteria. The SpreadsheetKey and WorksheetId are required and can be retrieved using the RetrieveSpreadsheetDetailsByName Choreo.

      The Query input is used to produce a feed with entries that meet your specified criteria. You can specify a structured quey like: ColumnName>5

      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: 0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E
      WorksheetId: od4
      Query: id>4

      The following is a sample of the XML information returned by this Choreo:

      <?xml version='1.0' encoding='UTF-8'?>
<feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearch/1.1/' xmlns:gsx='http://schemas.google.com/spreadsheets/2006/extended' xmlns:gd='http://schemas.google.com/g/2005' gd:etag='W/&quot;C0ADQ308cSp7ImA9WhRRFU8.&quot;'>
  <id>https://spreadsheets.google.com/feeds/list/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/od4/private/full</id>
  <updated>2011-11-28T23:09:32.379Z</updated>
  <category scheme='http://schemas.google.com/spreadsheets/2006' term='http://schemas.google.com/spreadsheets/2006#list'/>
  <title>baz</title>
  <link rel='alternate' type='text/html' href='https://spreadsheets.google.com/ccc?key=0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E'/>
  <link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/od4/private/full'/>
  <link rel='http://schemas.google.com/g/2005#post' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/od4/private/full'/>
  <link rel='self' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/od4/private/full?sq=id%3E3'/>
  <author>
    <name>Stan</name>
    <email>tembootest@gmail.com</email>
  </author>
  <openSearch:totalResults>2</openSearch:totalResults>
  <openSearch:startIndex>1</openSearch:startIndex>
  <entry gd:etag='&quot;WSp7ImA6&quot;'>
    <id>https://spreadsheets.google.com/feeds/list/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/od4/chk2m</id>
    <updated>2011-11-28T23:09:32.379Z</updated>
    <app:edited xmlns:app='http://www.w3.org/2007/app'>2011-11-28T23:09:32.379Z</app:edited>
    <category scheme='http://schemas.google.com/spreadsheets/2006' term='http://schemas.google.com/spreadsheets/2006#list'/>
    <title>4</title>
    <content></content>
    <link rel='self' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/od4/private/full/chk2m'/>
    <link rel='edit' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/od4/private/full/chk2m'/>
    <gsx:id>4</gsx:id>
  </entry>
  <entry gd:etag='&quot;Wip7ImA6&quot;'>
    <id>https://spreadsheets.google.com/feeds/list/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/od4/ciyn3</id>
    <updated>2011-11-28T23:09:32.379Z</updated>
    <app:edited xmlns:app='http://www.w3.org/2007/app'>2011-11-28T23:09:32.379Z</app:edited>
    <category scheme='http://schemas.google.com/spreadsheets/2006' term='http://schemas.google.com/spreadsheets/2006#list'/>
    <title>5</title>
    <content></content>
    <link rel='self' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/od4/private/full/ciyn3'/>
    <link rel='edit' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/od4/private/full/ciyn3'/>
    <gsx:id>5</gsx:id>
  </entry>
</feed>
Welcome to Temboo
Program the world. Generate code in less than 10 minutes.
What type of code would you like to generate?
Arduino
Texas Instruments
Samsung
C#
Java
JavaScript
Node.js
PHP
Processing
Python
REST API
Ruby
iOS
Android