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 object which 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/ > > 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. > 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.
