A week ago we announced how to bring Junar Data Streams into Google Spreadsheets.

Google insisted on returning the favor so it is possible now to publish Data Streams from pieces of Tables in your Google Spreadsheets !

Say you are passionate about Venture Capital, you have extracted some interesting information from LinkSV, and you now want to publish this data to the world. Here´s what you do:

#1 - You create the table you are interested in publishing and to honor the sources you write them below

#2 - You ensure that there are no protected areas in the document. This means that the column and row freeze bars are in the top left corner as you can see in the image above.

#3 - You need to publish the sheet in which the table is located. Ensure that you (i) publish as a webpage, (ii) select ONLY the one sheet.

#4 - You can get the link of this public sheet

#5 - And now you go to Junar to "collect a new Data Stream" as you already know, or you just use our bookmarklet if you are a Junar Ninja

And in case you want to check out this Data Stream, just go visit "Last 50 VC investments distribution"

Cheers, 

The Junar team

A new feature released by Junar, here it is: Insert live data streams into your Google Spreadsheets.

Very simple

1. Find the Data Stream you like (in this example a LinkSV sourced Data Stream on investments in Silicon Valley)

2. Click on ´Actions´ and then on ´Google Spreadsheets´ to get the ´code´

   -> =ImportHtml("http://www.junar.com/datastreams/html/34755/top-10-largest-vc-rounds-in-2011-linksv-investments-summary/" ; "table" ; 1)

3. Then, just go to your google Doc and insert the code in a cell

4. The Data Stream coming from a site in the web (or from a computer of a Junar Data Publisher) will be updated by Junar in your google doc

For sharing Spreadsheets you certainly use Google Docs... Start embedding live data from the web that you find in the Junar growing catalog of pre-curated data. Let us know what you think (support@junar.com).

Junar has now opened its Engine for developers to do some magic with it. We'll keep working on it such that you can always get the live data coming from different sites in the web or from different users publishing relevant data they own. We have a created a page with all the information and documentation so all developers can get started on how to use it: http://www.junar.com/developers/

Developers can now focus on creating interesting applications that we will promote as much as we can.

The Junar server API enables direct access to the Junar data catalog and engine from your application. It allows discovering Data Streams & dashboards, invoking Data Streams, and soon....collecting data and publishing it as Data Streams.  It uses a RESTful interface and returns data in JSON.

Data streams invoked through the API provide online and standarized  access to data contained in HTML pages, XLS and CSV files available on the web.

- What is a Data Stream? A Data Stream is a set of data collected by a Junar user from several sources in the web to even self-publishing of relevant data that Junar users posess and want to share. Junar keeps the Data Streams updated.

- What is a Dashboard? A Dashboard is a group of Data Streams that a Junar user creates. For some crazy reason Junar users like grouping data that together make sense.

If you are interested in playing with our API, please send us an email at Develpers@Junar.com or contact Joaco aka APIMan if you have any doubt.

Junar Team

Click here to download:

07_Junar-Api-Doc.pdf (93 KB)

(download)

Click here to download:

07_Junar-Api-Doc.pdf (93 KB)

by André

As we settle in Chile, the development team starts to speed up as more people come onboard. We are very very close to sign on board two-three new members to the dev team which will lead to Junar going to Warp Speed to our Beta Launch new year. 

Next week we will have the first meeting of the 'Beta Testing Unit' a group formed by students that will 'test drive' Junar. More info next week.