David, The spreadsheet url in my line of code is followed by /od6/ The od6 usually refers to the first sheet of the spreadsheet. When I made up a spreadsheet from within drive this was the case. When I started by making a web form and then had the form make up a responses spreadsheet the first sheet looked like this ookxz0b. I never got the spreadsheet with the form attached to work with Exhibit.
I read quite a few web pages looking for a way to figure out how to get that reference. I bookmarked some of them but apparently not the ones that ended up working. I think this is the page that I ended up using to get the URLs needed to get the worksheetId This is the Google API https://developers.google.com/google-apps/spreadsheets/#retrieving_information_about_worksheets >From that document try https://spreadsheets.google.com/feeds/worksheets/key/private/basic Replace the word key with your key In the document that is returned look for something like this " https://spreadsheets.google.com/feeds/worksheets/0AkgOV8gxmgPadGV3bTVxREZvb05jNUhxaGNQZ2lFZ2c/private/basic/od6 " In this case the first sheet in the spreadsheet is the od6, Yours might be different. Try the URL for the JSON data in my exhibit with both your key and the sheet reference. If that doesn't work try this URL from the Google API https://spreadsheets.google.com/feeds/cells/key/worksheetId/private/basic This should return each of the cells in the spreadsheet once you replace the key and worksheetId in the URL Also note that the spreadsheet needs to be "Published to the web" using the File>>Published to the web... menu item and not the "Public on the web" option for sharing in the Share button dialog box. Let me know if this works for you. George Adams On Wed, Aug 6, 2014 at 9:36 AM, David Karger <[email protected]> wrote: > How did you figure out the appropriate url? The new "publish" dialog is > giving me a url that I can't easily convert (e.g., putting my key in your > url doesn't work). > > > On 8/6/2014 4:13 AM, George Adams wrote: > > This test version of a Seed Library is running off of a new Google > Spreadsheet. > http://hayriv.com/seeds.html > > I did have an exhibit connected to an older Google spreadsheet and it > was easier to figure out the proper URL to use. I even checked the old > spreadsheet and it still has options for publishing to the web that no > longer exist with the new Google spreadsheets. The option to publish just a > single sheet no longer exists in the dialog box. > > George Adams > > > On Wed, Aug 6, 2014 at 12:24 AM, David Karger <[email protected]> > wrote: > >> Has anyone figured out how to get an exhibit json feed from the >> new/changed google spreadsheets? >> -- >> You received this message because you are subscribed to the Google Groups >> "SIMILE Widgets" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/simile-widgets. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > You received this message because you are subscribed to the Google Groups > "SIMILE Widgets" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/simile-widgets. > For more options, visit https://groups.google.com/d/optout. > > > -- > You received this message because you are subscribed to the Google Groups > "SIMILE Widgets" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/simile-widgets. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "SIMILE Widgets" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/simile-widgets. For more options, visit https://groups.google.com/d/optout.
