is this going to break all our old exhibits? all spreadsheets created in the old version of Google Sheets are being migrated to the new version https://support.google.com/docs/answer/6082736?p=old_sheets_migrate&rd=1
On Wed, Aug 6, 2014 at 4:49 PM, George Adams <[email protected]> wrote: > 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. > -- 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.
