Jon, do you need to access stuff at the api level for some reason?
Because exhibit will automatically import and display data that you
access using the gsheets urls generated by that page I sent you.
On 1/4/2017 7:08 PM, Jon Crump wrote:
Hi David,
Thanks for responding so swiftly. Yes, based on my experience with
Ex2, I had gotten as far as constructing a json-p url, and it returns
a gdata.io.handleScriptLoaded() function which wraps a json
objectwhich I've pretty printed below. (the toy spreadsheet is here
<https://docs.google.com/spreadsheets/d/1d4LtDRQaIDAb-1CplH14UoRoKdtsKsAivXfOckinU4U/edit#gid=0>)
What I'm wondering now is how to address that data in the exhibit html
to get a table representation of the spreadsheet rows. I gather that
Ex3 uses a different expression language from Ex2. All of the examples
at simile-widgets.org
<http://www.simile-widgets.org/exhibit3/examples/>draw their data from
purpose-built js objects rather than a google spreadsheet, and without
a working example, I'm a little unsure how to proceed.
|
{'encoding':'UTF-8',
'feed':{'author':[{'email':{'$t':'[email protected]'},
'name':{'$t':'jjcrump'}}],
'category':[{'scheme':'http://schemas.google.com/spreadsheets/2006',
'term':'http://schemas.google.com/spreadsheets/2006#list'}],
'entry':[{'category':[{'scheme':'http://schemas.google.com/spreadsheets/2006',
'term':'http://schemas.google.com/spreadsheets/2006#list'}],
'content':{'$t':'bar: barbell, bing: bingarang, baz: bazkite',
'type':'text'},
'id':{'$t':'https://spreadsheets.google.com/feeds/list/1d4LtDRQaIDAb-1CplH14UoRoKdtsKsAivXfOckinU4U/od6/public/basic/cokwr'},
'link':[{'href':'https://spreadsheets.google.com/feeds/list/1d4LtDRQaIDAb-1CplH14UoRoKdtsKsAivXfOckinU4U/od6/public/basic/cokwr',
'rel':'self',
'type':'application/atom+xml'}],
'title':{'$t':'row1','type':'text'},
'updated':{'$t':'2017-01-04T21:50:19.545Z'}},
{'category':[{'scheme':'http://schemas.google.com/spreadsheets/2006',
'term':'http://schemas.google.com/spreadsheets/2006#list'}],
'content':{'$t':'bar: barbibble, bing: bingbabble, baz: bazurote',
'type':'text'},
'id':{'$t':'https://spreadsheets.google.com/feeds/list/1d4LtDRQaIDAb-1CplH14UoRoKdtsKsAivXfOckinU4U/od6/public/basic/cpzh4'},
'link':[{'href':'https://spreadsheets.google.com/feeds/list/1d4LtDRQaIDAb-1CplH14UoRoKdtsKsAivXfOckinU4U/od6/public/basic/cpzh4',
'rel':'self',
'type':'application/atom+xml'}],
'title':{'$t':'row2','type':'text'},
'updated':{'$t':'2017-01-04T21:50:19.545Z'}}],
'id':{'$t':'https://spreadsheets.google.com/feeds/list/1d4LtDRQaIDAb-1CplH14UoRoKdtsKsAivXfOckinU4U/od6/public/basic'},
'link':[{'href':'https://docs.google.com/a/uw.edu/spreadsheets/d/1d4LtDRQaIDAb-1CplH14UoRoKdtsKsAivXfOckinU4U/pubhtml',
'rel':'alternate',
'type':'application/atom+xml'},
{'href':'https://spreadsheets.google.com/feeds/list/1d4LtDRQaIDAb-1CplH14UoRoKdtsKsAivXfOckinU4U/od6/public/basic',
'rel':'http://schemas.google.com/g/2005#feed',
'type':'application/atom+xml'},
{'href':'https://spreadsheets.google.com/feeds/list/1d4LtDRQaIDAb-1CplH14UoRoKdtsKsAivXfOckinU4U/od6/public/basic',
'rel':'http://schemas.google.com/g/2005#post',
'type':'application/atom+xml'},
{'href':'https://spreadsheets.google.com/feeds/list/1d4LtDRQaIDAb-1CplH14UoRoKdtsKsAivXfOckinU4U/od6/public/basic?alt\\u003djson-in-script',
'rel':'self',
'type':'application/atom+xml'}],
'openSearch$startIndex':{'$t':'1'},
'openSearch$totalResults':{'$t':'2'},
'title':{'$t':'Sheet1','type':'text'},
'updated':{'$t':'2017-01-04T21:50:19.545Z'},
'xmlns':'http://www.w3.org/2005/Atom',
'xmlns$gsx':'http://schemas.google.com/spreadsheets/2006/extended',
'xmlns$openSearch':'http://a9.com/-/spec/opensearchrss/1.0/'},
'version':'1.0'}
|
On Wednesday, January 4, 2017 at 3:22:34 PM UTC-8, David Karger wrote:
Jon, google made it much more mysterious to get json feeds from
their spreadsheets. We built a little form to help; let me know
if this solves your problem:
http://projects.csail.mit.edu/exhibit/googleJSON/
<http://projects.csail.mit.edu/exhibit/googleJSON/>
On 01/04/2017 03:23 PM, Jon Crump wrote:
Dear all,
I'm returning to Exhibit after long hiatus, and I'm trying to get
my head around Exhibit3. Are there any examples out there of
bare-bones Exhibit demo drawing data from a Google spreadsheet?
I've got a link:
<link rel="exhibit/data"
type="application/jsonp"
href="https://spreadsheets.google.com/feeds/list/xxxxx-mysheetid/od6/public/basic?alt=json-in-script";
<https://spreadsheets.google.com/feeds/list/xxxxx-mysheetid/od6/public/basic?alt=json-in-script>
ex:converter="googleSpreadsheets" />
that returns some pretty opaque looking json wrapped in a
gdata.io.handleScriptLoaded() function, and I've called Exhibit thus:
<script src="./scripted/src/exhibit-api.js?bundle=false"
type="text/javascript"></script>
but I'm somewhat at a loss to know how to go next.
any hints for the clueless, but willing, would be welcome.
thanks,
Jon
-- 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] <javascript:>. To post to this
group, send email to [email protected] <javascript:>.
Visit this group at
https://groups.google.com/group/simile-widgets
<https://groups.google.com/group/simile-widgets>. For more
options, visit https://groups.google.com/d/optout
<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]
<mailto:[email protected]>. To post to this
group, send email to [email protected]
<mailto:[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.
