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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/simile-widgets. For more options, visit https://groups.google.com/d/optout.
