see the rfq i posted. there are a variety of issues in merggoogle 1. mac/ios only 2. doesn't seem to work in newer versions of lc for some reason (works in 9.0.1, for instance, but not in 9.5.x) 3. google is going to shut off...something...that merggoogle is using in september. i don't know what that is, but i get emails from google telling me that i'm using a deprecated api that is going to be nuked in six months. the only place that i could possibly be using that api is merggoogle 4. we have had to include a lot of error trapping code because merggoogle somehow gets out of step with google, which breaks the process, and it is impossible to debug because of the way merggoogle works (you can't see all the raw traffic). so for example, we might say "load a worksheet", and instead we will get a message that the list of spreadsheets is loaded. the problem with that is that there is no way to recover once that happens, and you have to start over. there are multiple bug reports on this particular issue, but the workaround was a lot of workaround code to specifically ensure that the sequence occurs as expected. 5. the rest api seems like it has more features 6. there doesn't seem to be any interest in updating merggoogle.
On Wed, Mar 11, 2020 at 4:46 PM Ben Rubinstein via use-livecode < use-livecode@lists.runrev.com> wrote: > Hi Mike, > > I haven't forgotten, but finally found time to take a look today and > started > writing minimal comments, and thought I should at least test it - for some > reason the authorisation isn't working. For whatever reason, the call to > OAuth2 results in the error "Malformed auth code." So I can't get to test > what > I'm sending. > > I'm unclear whether I've done something strange or wrong, or whether > Google > has changed something that breaks LC's implementation. I've come across > references which suggest that, but they date back to last year, and I > believe > I've used this stack in January. (I also tried using LC 9.0.4 with the > same > result.) > > I will try to get back to this. In the meantime, have you - or anyone - > found > issues recently with OAuth2, in particular against any of the Google APIs? > > Ben > > > On 08/03/2020 22:22, Mike Kerner via use-livecode wrote: > > it might help us get started. i'm going to probably put out an rfq to > wrap > > the v4 rest api, because we're going to have to come to a solution, > either > > using lc or some other tool. > > > > On Sun, Mar 8, 2020 at 6:01 PM Ben Rubinstein via use-livecode < > > use-livecode@lists.runrev.com> wrote: > > > >> Mike, > >> > >> Very happy to share what I've got, but it's really not much - just a > very > >> thin > >> wrapper round Google's API - and it's undocumented, mostly rough code - > >> copied > >> from one stack to the next, usually done in a tearing hurry! > >> > >> I'll try to pull something together, but please promise not to judge > me... > >> > >> Ben > >> > >> On 06/03/2020 15:13, Mike Kerner via use-livecode wrote: > >>> Ben, > >>> would you send me what you've got? I was considering paying someone to > >>> wrap the entire v4 api and dropping mergGoogle, so any head start would > >> be > >>> useful. LC wants tribute to do the work (which is a little > disappointing > >>> since we financed the original external, so we sort-of hoped that it > >> would > >>> become a thing, and it would get updated as required, but crap > happens). > >>> > >>> On Thu, Mar 5, 2020 at 6:04 PM Ben Rubinstein via use-livecode < > >>> use-livecode@lists.runrev.com> wrote: > >>> > >>>> On 04/03/2020 20:37, Mike Kerner via use-livecode wrote: > >>>>> is anyone using anything besides mergGoogle to work with google > sheets? > >>>>> care to share, if you are? > >>>> > >>>> I'm just using the Google Sheets API directly from LiveCode - just > >> pushing > >>>> JSON back and forth. The API is limited, but what's there is very easy > >> to > >>>> work > >>>> with - much better than manipulating xlsx files. > >>>> > >>>> I started using it to get data from clients, and then processing data > >> and > >>>> pushing it back into the sheets. I've also used on some experimental > >> image > >>>> processing, where I found that pushing the results of LiveCode > functions > >>>> into > >>>> a google sheet immediately gave me an nice interface in which to > review > >>>> the > >>>> data, and then I could also use the spreadsheet functions to do > >> evaluation > >>>> and > >>>> testing. > >>>> > >>>> Ben > >>>> > >>>> ____ > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > -- On the first day, God created the heavens and the Earth On the second day, God created the oceans. On the third day, God put the animals on hold for a few hours, and did a little diving. And God said, "This is good." _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
