Yes, I use js function to read external JSONP " in your tidder under "////////Начало нового кода////////" just open it <https://heeg.ru/shop2_3.html#$:/boot/bootprefix1.js> in is very simple. It works faster then FETCH To test it work open https://heeg.ru/shop2_3.html#%24%3A%2FControlPanel and press "*залить данные из гугл таблицы СЕЙЧАС*" spreadsheet must have lists "goods, parts, images, system" So you have to rewrite my code not to use this lists names. Here are examples, how we can use google spreadsheet id in URL https://groups.google.com/g/heeg/c/G0eSqbJBvZg/m/9Jr0dtu6CAAJ 2. I dont use doGET() and doPOST() in my projects now, but I plan to use it, because it is new and more interesting instrument of googlespreadsheet
понедельник, 21 февраля 2022 г. в 22:57:14 UTC+3, Mat: > Siniy-Kit wrote: > >> 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({......}) >> > > So... the output in that link is a js function and some more stuff that > wraps the JSON. So, do you *scrub off* the wrapping stuff to accss the > clean JSON content or do you *use* the js function in your own code? > ...and is the scrubbing or use of the js function what you have in your > tidder under "////////Начало нового кода////////" ? > > >> 2) new variant with doGET() in google script >> > > This looks very interesting. If I interpret these docs > <https://developers.google.com/apps-script/guides/web#request_parameters>, > it seems very direct to both get and post content from and to a sheet > (which is one big limitation in the current TiddlyGoo solutions; there is > no solution to push data to a sheet from TW). > But, @Siniy-kit, you currently don't use doGet or doPost at all, right? > You solve *both* push and pull with JSONP, right? > > Thank you for your replies. > > <:-) > -- 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/87af9a75-83fe-4e98-a0c4-dffa19945752n%40googlegroups.com.
