Wow, thanks Eric! It sounds as if this could work almost exactly as I was hoping, that's great.
I just was reading the docs again as before finding your post, and there is some API calls it looks like to 'sign in' a user using a name/password and create a session handle to use for all my API traffic. Can I re-use this session for the user to be single-signed-on for using the Google Docs UI also? I hope the question makes a little sense, lol. Thanks again for the help, I'm really grateful Google makes such great products and is so willing to also help the community use them!! - sal On Wed, Nov 12, 2008 at 6:25 PM, Eric (Google) <[EMAIL PROTECTED]> wrote: > > Hi sal, > > Comments are below. > > On Nov 12, 12:51 pm, sal <[EMAIL PROTECTED]> wrote: > > I did a little bit of research into the docs - but still haven't been > > able to identify if what I'm trying to do is possible, I was hoping > > someone here might be able to help: > > > > Basically I have a website, written in Java. I would like to dump to > > a Google spreadsheet when a user does a database query. However I > > would like to dump it into a spreadsheet on the user's Google Docs > > account, and he can edit the contents within my web page (At least > > appear to do this... I don't mind if its just an iframe that > > references the 'real' Google Docs site.) > > > > So a few questions: > > > > - 1. I'm guessing I can create / write to the file using the Google > > Docs API, under that users' account - am I correct? > > Correct. You can use the API to create and populate > the initial doc. You can also use the API to edit the spreadsheet, > it's cells, etc. > > > - 2. Can I generate a URL linking to this file and show the editor for > > it within my web page? > > You could iframe the doc itself. The iframe's src would be the URL > of the published doc (this is the same as the alternate link's href > value when using the API: <link rel='alternate' href=''/> > > http://code.google.com/apis/spreadsheets/developers_guide_protocol.html#worksheetsFeedExample > > > - 3. I would like to single-sign on the user with my website - is it > > possible? Or do I have to show a 2nd login screen when they attempt to > > view the google spreadsheet? > > As you can imagine, iframing the spreadsheet isn't a perfect solution. > The user will be prompted to authenticate (only if they're not > already > logged into their Google Account). If they _do_ need to login, > Docs will break out of the iframe. > > > > > The reason for embedding is to let them use all the features of the > > Google Spreadsheets but not have to navigate away from my site and > > confuse them with managing the multiple browser windows / etc. > > > > Thanks much in advance for any help!!! I'll keep searching also... > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Docs Data APIs" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Google-Docs-Data-APIs?hl=en -~----------~----~----~----~------~----~------~--~---
