Hi Yaroslav, You have found something very interesting there! It seems like one could request the data, but forgo asking a visualisation component to draw it ... and do something else with it instead. This would work in both JavaScriptInABrowser and other contexts (eg. JavaOnAServer ... although one will first have to implement a Java *client* library for the Data Source protocol and resort to some odd authentication scenarios).
To tentatively answer your questions: 1) Google nowhere documents how the Visualisation API passes your Google session information from the browser to the spreadsheets implementation of the Data Source URL. However, it is likely to be cookie-based, rather than header-based as in the GData protocol. So no AuthSub, probably. More research is required. 2) The Google-supplied Table visualisation (for example) doesn't allow you to manipulate the data. This is partly on account of the Data Source protocol which doesn't support updates. However, that doesn't mean you couldn't combine use of the visualisation API with the GData API. In fact, this usage seems to be anticipated at http://code.google.com/apis/visualization/documentation/spreadsheets.html#Testing_in_Spreadsheets where it says "Note that you cannot write to the spreadsheet using the Visualization API; to write to the spreadsheet programmatically, you should *add* the Google Spreadsheets GData API<http://code.google.com/apis/spreadsheets/overview.html> *to your visualization*." (my emphasis). This might only suit some applications though - it would seem that the underlying Data Source wire protocol doesn't support incremental updates (although it supports saying 'no changes here'). This means more work - especially since Google's own visualastions do NOT appear to be open-source. But there's nothing to say your 'visualisation' couldn't be an editable GWT table, for example. Anyhow, my final take on this is that using the Visualisation API to compensate for the lack of a 'like' operator in the List API would be like using a hammer to compensate for not having a screwdriver. But it might well be a useful API for 'dashboards' which presented a reporting-style graphical view of the contents of the spreadsheet. Good Luck, David. On Wed, Apr 27, 2011 at 5:12 PM, Yaroslav Rybak <[email protected]> wrote: > I found that we can get data using Google Visualisation, > > but it's without entry and rowid or any of id that i can find > using Spreadsheets Api. > > also i found that Visualization Api provide access to spreadsheet some sort > query > example we can use like > > *select * where A contains 'some text'* > > with Spreadsheets we can use only > < = and or search not sctring contains > > but we can use Google Visualisation with Spreadsheets using Google Auth, > every time need login to Spreadsheet, > > It's possible combine/use GData for Visualisation with AuthSub, and if it's > possible or how i can edit Spreadsheets using reslut from Google > Visualisation >
