Hi David, The url http://people.csail.mit.edu/karger/Exhibit/Papers/ <http://www.google.com/url?q=http%3A%2F%2Fpeople.csail.mit.edu%2Fkarger%2FExhibit%2FPapers%2F&sa=D&sntz=1&usg=AFQjCNHD4ux7k45rFUdkb1Eq030KZySxaA> complains about MathZoom.js & similar dependencies. If you disregard the 'ReferenceError: Exhibit is not defined' the page can be loaded locally. As Sheets to JSON isn't working anymore I tried using Google Publish to web with the csv option but so far haven't been able to make the csv file load. Is there any plan to get Sheets to JSON up and running again or is csv definitely the way to go from here on? All the very best, Daniel
On Saturday, December 1, 2018 at 5:21:53 PM UTC-5, David Karger wrote: > > Note that the latest incarnation of gdocs will also let you get a link to > the data as a csv file that you can read into exhibit using the text/csv > data type. See for example > http://people.csail.mit.edu/karger/Exhibit/Papers/ > > ------ Original Message ------ > From: "jjon" <crum...@gmail.com <javascript:>> > To: "SIMILE Widgets" <simile-...@googlegroups.com <javascript:>> > Sent: 12/1/2018 4:32:11 PM > Subject: [Simile-Widgets] Re: Using Sheets to JSON > > Hi Shawn, > > This is what worked for me. I had a spreadsheet at > > https://docs.google.com/spreadsheets/d/1qZ6Sgu2qcKy-Rbc-L_5YN-zJD2jErOw2BUhur3-yWlk/edit#gid=0 > > Note that 1qZ6Sgu2qcKy-Rbc-L_5YN-zJD2jErOw2BUhur3-yWlk is the ID for the > sheet. > > I did "publish to the web" and the dialog gave me this url: > > https://docs.google.com/spreadsheets/d/e/2PACX-1vSXmb6tv3ThsUp_uBnvLuB9PEA7C5eifsDpV5Wa1q68Xq0j8xerH6liR_IWuL-ykPQJzWVSalRPKkrj/pubhtml > > Now ignore that URL. This is the <link> I put in the head of my Exhibit > page to access JSON from that spreadsheet: > <link rel="exhibit/data" type="application/jsonp" > href=" > https://spreadsheets.google.com/feeds/list/1qZ6Sgu2qcKy-Rbc-L_5YN-zJD2jErOw2BUhur3-yWlk/od6/public/basic?hl=en_US&alt=json-in-script > " > data-ex-converter="googleSpreadsheets" /> > > > Notice that it uses the ID from the URL used to access the sheet directly. > > More recently, for a different Exhibit, I found I had to further tinker > with a data link URL such that: > https:// > spreadsheets.google.com/feeds/list/standardSheetURL_ID/1/public/basic?hl=en_US&alt=json-in-script#gid=115609054 > " > > > > > Notice that /od6/ has been replaced by the number of the sheet: /1/; and, > the gid has been tacked on to the end. > I found this blog post > <http://cwestblog.com/2018/03/25/google-sheets-data-as-json-jsonp/> > instructive as well. > > Also, note David Karger's post > <https://groups.google.com/d/msg/simile-widgets/ctqxFM9dvgA/Yl8dwybIEQAJ> > to the list here. > > Google keeps tinkering with stuff, and is not always very transparent > about it. > > Jon > > On Saturday, December 1, 2018 at 12:59:47 PM UTC-8, Shawn Day wrote: >> >> I used to use the lovely URL converter to take a shared Google Sheet and >> make it available as a JSON data source for Exhibit. >> When I attempted to use : >> https://docs.google.com/spreadsheets/d/e/2PACX-1vQIJyC-n5M3OKQbRT7FgdPrhxxDNuZZNebJprFRFlhgTLAUUpk97hTvoct0P5nn2Gye0T2bVd6DUfN8/pubhtml >> >> a very simple google sheet, it returns the error "Could not access >> page/Could not find page data." despite the fact that the sheet is both >> shared and published. >> Any assistance greatly appreciated. I attempted to truncate the URL by >> removing the pubhtml with no luck. >> Thanks in advance, >> Shawn >> > > > On Saturday, December 1, 2018 at 12:59:47 PM UTC-8, Shawn Day wrote: >> >> I used to use the lovely URL converter to take a shared Google Sheet and >> make it available as a JSON data source for Exhibit. >> When I attempted to use : >> https://docs.google.com/spreadsheets/d/e/2PACX-1vQIJyC-n5M3OKQbRT7FgdPrhxxDNuZZNebJprFRFlhgTLAUUpk97hTvoct0P5nn2Gye0T2bVd6DUfN8/pubhtml >> >> a very simple google sheet, it returns the error "Could not access >> page/Could not find page data." despite the fact that the sheet is both >> shared and published. >> Any assistance greatly appreciated. I attempted to truncate the URL by >> removing the pubhtml with no luck. >> Thanks in advance, >> Shawn >> > -- > 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 simile-...@googlegroups.com <javascript:>. > To post to this group, send email to simile-...@googlegroups.com > <javascript:>. > Visit this group at https://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 simile-widgets+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/simile-widgets/967094a6-7ae7-4ca0-8995-41b40d94545e%40googlegroups.com.
