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" <crumpj...@gmail.com>
To: "SIMILE Widgets" <simile-widgets@googlegroups.com>
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 simile-widgets+unsubscr...@googlegroups.com.
To post to this group, send email to simile-widgets@googlegroups.com.
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 post to this group, send email to simile-widgets@googlegroups.com.
Visit this group at https://groups.google.com/group/simile-widgets.
For more options, visit https://groups.google.com/d/optout.
