Hola, Daniel, Well, the first approach, as Ben says, works fine now, but it returns a json that you must arrange to work with exhibit[1] if you use this spreadsheet for example [2] with this url [3] as Ben suggests.
I think it's easier to use csv from google spreadsheets directly. Or you can get the csv and convert internally to json, but exhibit can read right the csv. [1] https://gist.github.com/lmorillas/cbf2a0fb4a28ba7d016568ac9269bd37 [2] https://docs.google.com/spreadsheets/d/1v-b_AaChE431LvPLlGFSykJFoD--OKRBOjqgiZ7hqPA/edit#gid=180101019 [3] https://docs.google.com/spreadsheets/d/1v-b_AaChE431LvPLlGFSykJFoD--OKRBOjqgiZ7hqPA/gviz/tq?tqx=out:json Saludos, -- luismiguel (@lmorillas) El vie, 20 ago 2021 a las 21:46, dhinostroza (<[email protected]>) escribió: > > Hi Luis Miguel and David, > I tested Ben Borgers solution first and it didn't work on the first go. Maybe > it's just a matter of tweaking it a bit further to get the settings right... > So, I then tested Luis Miguel's solution (publishing the Google spreadsheet > to csv and replacing the json link with the full published as csv link in my > SIMILE page) and it worked perfectly. > It looks like this (I made up the column titles for this example): > <link > href="https://docs.google.com/spreadsheets/d/e/2PACX-1vSq-fac7XtI1IXXXXXXxxXXXXXxxXXXXXXxXXXXNXXXXXXXXXXXX_XXXXXXXXX_XXXXXXXXXXXXXXXX/pub?gid=1300000000&single=true&output=csv"; > type="text/csv" rel="exhibit/data" > data-ex-properties="label,ID,Lname,Fname,Email,Observations" > data-ex-has-column-titles="true"/> > I'm using the full path to exhibit-api > (http://api.simile-widgets.org/exhibit/3.1.2rc2/exhibit-api.js) url but the > shortened (//api.simile-widgets.org/exhibit/current/exhibit-api.js) has also > worked for me in other projects. > Thank you! > Daniel > > On Friday, August 20, 2021 at 2:01:37 AM UTC-5 Luis Miguel Morillas wrote: >> >> David, I think that it is the old method that has been removed now. >> >> Saludos, >> >> -- luismiguel (@lmorillas) >> >> El vie, 20 ago 2021 a las 4:08, David Karger (<[email protected]>) escribió: >> > >> > According to this article: >> > >> > https://benborgers.com/posts/google-sheets-json >> > >> > the following should work: >> > >> > https://spreadsheets.google.com/feeds/list/spreadsheet_key/1/public/values?alt=json >> > >> > that is, replace /od6/public/basic?alt=json-in-script at the end with >> > /1/public/values?alt=json >> > >> > >> > On 8/18/2021 11:08 AM, Luis Miguel Morillas wrote: >> > > I'm afraid the Data API is down [1]. Look at >> > > https://docs.google.com/feeds/list/1H38J-cLEAt8VhDuhMvJgSGH4KzT0LrhFl9tvGTQpqWI/1/public/values?alt=json-in-script >> > > You can use csv export either. >> > > >> > > [1] https://developers.google.com/gdata/docs/json >> > > >> > > Saludos, >> > > >> > > -- luismiguel (@lmorillas) >> > > >> > > El mié, 18 ago 2021 a las 15:13, Andrea Borruso (<[email protected]>) >> > > escribió: >> > >> Hi, >> > >> I used for some simile pages this kind of URL: >> > >> >> > >> https://spreadsheets.google.com/feeds/list/1H38J-cLEAt8VhDuhMvJgSGH4KzT0LrhFl9tvGTQpqWI/od6/public/basic?alt=json-in-script >> > >> >> > >> But none of these URLs work anymore. >> > >> >> > >> What's the new URL schema for this kind of output? >> > >> >> > >> Thank you >> > >> >> > >> -- >> > >> 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 view this discussion on the web visit >> > >> https://groups.google.com/d/msgid/simile-widgets/8b661bc0-6887-4491-8349-34fb0f290a25n%40googlegroups.com. >> > >> > -- >> > 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 view this discussion on the web visit >> > https://groups.google.com/d/msgid/simile-widgets/43e5cf7b-783f-68fb-129f-e93e33f7ddfa%40mit.edu. > > -- > 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 view this discussion on the web visit > https://groups.google.com/d/msgid/simile-widgets/0caa446b-b900-49f6-8138-feacb2531057n%40googlegroups.com. -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/simile-widgets/CAFQDTO1fC3MP_4twoDRSbVfWtvcN0Z6ayuaY%3DBfokNP%2BPG95sQ%40mail.gmail.com.
