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" <[email protected]>
To: "SIMILE Widgets" <[email protected]>
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:
<linkrel="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
<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
<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.
--
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.
