No, JSONP is working all over the world (not only in Russia) 3) Old variant with alt=json-in-script is not working now, *BUT we have two another ways*
1) very very very old JSONP (*I use it now*) https://spreadsheets.google.com/tq?key=16jpYS8egNJuLA8HyS-Um6wuwC9A5eFl-IKykIzZB92Y&sheet=goods here we have js function with JSON argument. google.visualization.Query.setResponse({......}) 2) new variant with doGET() in google script понедельник, 21 февраля 2022 г. в 01:32:58 UTC+3, Mat: > Mark S. wrote: > >> Yeah, that's what we're using. I think. Possibly Google hasn't shut it >> down in all regions, or possibly there is something else wrong with your >> (Mat's) particular use-case that has nothing to do with the status of JSONP. >> > > Hmm... @Siniy-kit what do I misunderstand: > > 1) Your solution is fetching data from a google sheet. > 2) You can only fetch this because the sheet data is presented in json > format thanks to a google feature that requires a special URL > 3) This special URL *used to* have the format: > https://spreadsheets.google.com/feeds/worksheets/"+specs.id > +"/public/values?alt=json-in-script > 4) ...but google modified this in august last year so the special URL is > different AND the presented data there is json but it is wrapped in some > other stuff. Here is the *new* URL format: > https://sheets.googleapis.com/v4/spreadsheets/' + spreadsheet_id + > '/values/' + tab_name + '?alt=json&key=' + api_key; > > OR are you using a completely different method to pull the data into your > wiki? One of the urls you just posted seems to be a script, so maybe there > is a local copy of some magic script in each sheet you share, or maybe > there's a way to apply a script to a arbitrary sheets to mangle them... > perhaps via a special url (like what you posted... but where is that script > stored then?) > > @Mark... any ideas? Am I and @Siniy-kit talking past one another? I'm the > fool here because I'm dealing with pieces in a puzzle that I don't > understand. Is my question wrong? > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/0fc578bf-0d8b-47a7-a064-83877e8e46f0n%40googlegroups.com.
