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

Ben Rubinstein benr at cogapp.com
Wed Mar 11 16:45:22 EDT 2020


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
>>>>
>>>> ____




More information about the use-livecode mailing list