This is GData <https://en.wikipedia.org/wiki/GData> - Google Data ATOM/RSS represented in JSON format. So originally it is in XML format. If you try in browser https://spreadsheets.google.com/feeds/*list* /1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4/01/public/basic <https://spreadsheets.google.com/feeds/list/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4/01/public/basic> in Chrome or FF then browser will get and recognize ATOM xml feed and ask you in which program to subscribe to this feed.
As described in example of retrieving JSON <https://developers.google.com/gdata/samples/spreadsheet_sample#introduction> *list*|*cells* define data in each *entry* array element. If entry element *per sheet cell* is needed then just get https://spreadsheets.google.com/feeds/*cells* /1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4/01/public/basic?alt=json <https://spreadsheets.google.com/feeds/cells/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4/01/public/basic?alt=json> воскресенье, 3 апреля 2016 г., 22:15:15 UTC+3 пользователь Jeremy Ruston написал: > > Hi Hegart > > Professor Schneider at *{{DesignWrite}}* has recently shared a link to this > blog post <https://ctrlq.org/code/20004-google-spreadsheets-json>, which > suggests it is possible to access the information in a Google Sheet as a > JSON file, by using jQuery. This looks very promising for my semester > project, but I have no idea how to implement it, as I am a total n00b at > Javascript. > > > Interesting. I checked it out, creating a simple public spreadsheet. The > sharing works as advertised, except that the JSON format used is pretty > complex, but parseable. > > My sample spreadsheet looks like this: > > > The resulting JSON is attached below. Weirdly, it doesn’t even place the > cells of the spreadsheet in separate entries; they’re merged together with > colons. > > Anyhow, I’m sure with a bit of research one could figure out the format > and get something useful out of it, but it feels a bit Google-specific > compared to the general utility of extending TW with the CSV import > facilities you need, > > Best wishes > > Jeremy. > > { > "version": "1.0", > "encoding": "UTF-8", > "feed": { > "xmlns": "http:\/\/www.w3.org\/2005\/Atom", > "xmlns$openSearch": "http:\/\/a9.com\/-\/spec\/opensearchrss\/1.0\/", > "xmlns$gsx": "http:\/\/schemas.google.com > \/spreadsheets\/2006\/extended", > "id": { > "$t": "https:\/\/spreadsheets.google.com > \/feeds\/list\/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4\/od6\/public\/basic" > }, > "updated": { > "$t": "2016-04-03T19:02:55.541Z" > }, > "category": [ > { > "scheme": "http:\/\/schemas.google.com\/spreadsheets\/2006", > "term": "http:\/\/schemas.google.com\/spreadsheets\/2006#list" > } > ], > "title": { > "type": "text", > "$t": "Sheet1" > }, > "link": [ > { > "rel": "alternate", > "type": "application\/atom+xml", > "href": "https:\/\/docs.google.com > \/spreadsheets\/d\/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4\/pubhtml" > }, > { > "rel": "http:\/\/schemas.google.com\/g\/2005#feed", > "type": "application\/atom+xml", > "href": "https:\/\/spreadsheets.google.com > \/feeds\/list\/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4\/od6\/public\/basic" > }, > { > "rel": "http:\/\/schemas.google.com\/g\/2005#post", > "type": "application\/atom+xml", > "href": "https:\/\/spreadsheets.google.com > \/feeds\/list\/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4\/od6\/public\/basic" > }, > { > "rel": "self", > "type": "application\/atom+xml", > "href": "https:\/\/spreadsheets.google.com > \/feeds\/list\/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4\/od6\/public\/basic?alt=json" > } > ], > "author": [ > { > "name": { > "$t": "jeremy.ruston" > }, > "email": { > "$t": "jeremy...@gmail.com <javascript:>" > } > } > ], > "openSearch$totalResults": { > "$t": "3" > }, > "openSearch$startIndex": { > "$t": "1" > }, > "entry": [ > { > "id": { > "$t": "https:\/\/spreadsheets.google.com > \/feeds\/list\/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4\/od6\/public\/basic\/cokwr" > }, > "updated": { > "$t": "2016-04-03T19:02:55.541Z" > }, > "category": [ > { > "scheme": "http:\/\/schemas.google.com\/spreadsheets\/2006", > "term": "http:\/\/schemas.google.com\/spreadsheets\/2006#list" > } > ], > "title": { > "type": "text", > "$t": "Once I" > }, > "content": { > "type": "text", > "$t": "two: caught a , three: fish, four: alive" > }, > "link": [ > { > "rel": "self", > "type": "application\/atom+xml", > "href": "https:\/\/spreadsheets.google.com > \/feeds\/list\/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4\/od6\/public\/basic\/cokwr" > } > ] > }, > { > "id": { > "$t": "https:\/\/spreadsheets.google.com > \/feeds\/list\/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4\/od6\/public\/basic\/cpzh4" > }, > "updated": { > "$t": "2016-04-03T19:02:55.541Z" > }, > "category": [ > { > "scheme": "http:\/\/schemas.google.com\/spreadsheets\/2006", > "term": "http:\/\/schemas.google.com\/spreadsheets\/2006#list" > } > ], > "title": { > "type": "text", > "$t": "Six" > }, > "content": { > "type": "text", > "$t": "two: Seven, three: Eight, four: Nine, five: Ten" > }, > "link": [ > { > "rel": "self", > "type": "application\/atom+xml", > "href": "https:\/\/spreadsheets.google.com > \/feeds\/list\/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4\/od6\/public\/basic\/cpzh4" > } > ] > }, > { > "id": { > "$t": "https:\/\/spreadsheets.google.com > \/feeds\/list\/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4\/od6\/public\/basic\/cre1l" > }, > "updated": { > "$t": "2016-04-03T19:02:55.541Z" > }, > "category": [ > { > "scheme": "http:\/\/schemas.google.com\/spreadsheets\/2006", > "term": "http:\/\/schemas.google.com\/spreadsheets\/2006#list" > } > ], > "title": { > "type": "text", > "$t": "Then I" > }, > "content": { > "type": "text", > "$t": "two: put it, three: in, four: again" > }, > "link": [ > { > "rel": "self", > "type": "application\/atom+xml", > "href": "https:\/\/spreadsheets.google.com > \/feeds\/list\/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4\/od6\/public\/basic\/cre1l" > } > ] > } > ] > } > } > > > > What I was thinking for this, is perhaps synchronising a set of tiddlers > of type *JSON data* from my Google Sheets > <http://bit.do/TiddlyCRM-sampledata>. Many of my worksheets in Google are > already formatted in such a way that they will generate TiddlyWiki > tiddlers, with just the relevant column headings as expected by TiddlyWiki, > and rows for each tiddler. I currently export these manually to CSV, then > convert them to JSON. This new idea would save on those extra steps. Once I > have them as *JSON data* tiddlers full of JSON tiddlers, I should then be > able to bulk import the tiddlers into my wiki space from the *JSON data* > tiddlers fairly easily. > > This solution would be used initially to replace my cumbersome procedure > for working with the SampleData which I'm generating for testing the > TiddlyCRM project. This sample data gets imported and purged often. > However, it may also have application later for the live data, if the end > user wants to bulk-import their legacy information into TiddlyCRM. > > Any advice on how to implement this would be greatly appreciated. > > Kind regards, > > Hegart. > > -- > You received this message because you are subscribed to the Google Groups > "TiddlyWiki" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to tiddlywiki+...@googlegroups.com <javascript:>. > To post to this group, send email to tiddl...@googlegroups.com > <javascript:>. > Visit this group at https://groups.google.com/group/tiddlywiki. > To view this discussion on the web visit > https://groups.google.com/d/msgid/tiddlywiki/fe13e647-fc37-4e68-8ec4-9be2ddc11353%40googlegroups.com > > <https://groups.google.com/d/msgid/tiddlywiki/fe13e647-fc37-4e68-8ec4-9be2ddc11353%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > > > -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To unsubscribe from this group and stop receiving emails from it, send an email to tiddlywiki+unsubscr...@googlegroups.com. To post to this group, send email to tiddlywiki@googlegroups.com. Visit this group at https://groups.google.com/group/tiddlywiki. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/6db4dd2d-59d0-4c56-ab13-6390a2d92084%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
