OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[Mike Kerner]

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 at 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 at 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 at 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 at 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."