Hi Bill (and Neville)

Happy to post it - I'll try to do a bit of cleanup and commenting first. (Honestly I think it's probably just going to be an email to the list.) Afore I do, I had this question:

(I say library - currently it's a button I copy and paste to stacks where I
need it, and "insert the script of". I've completely lost track of how real
"libraries" should be packaged. Where should I look?)
What is the currently approved method for a "library"?

TIA,

Ben

On 22/07/2020 20:04, Prothero@earthlearning via use-livecode wrote:
Ben,
Any chance of posting a demo stack somewhere? It sounds very useful.
Thanks,
Bill

William Prothero
http://es.earthednet.org

On Jul 22, 2020, at 10:13 AM, Ben Rubinstein via use-livecode 
<use-livecode@lists.runrev.com> wrote:

Ah, shame. It turned out it was (IIUC) just a change in the way Google did 
their tokens which exposed a bug, now fixed, in how LC did OAuth - nothing to 
do with the general API changing.

At any rate, I do have a very basic library which I use to read and write 
Google sheets, in case it's of use to anyone.

(I say library - currently it's a button I copy and paste to stacks where I need it, and 
"insert the script of". I've completely lost track of how real "libraries" 
should be packaged. Where should I look?)

Ben

On 21/07/2020 14:49, Mike Kerner wrote:
I got impatient/spooked so we went another direction.  I think we're going to 
use other tools.
On Thu, Jul 16, 2020 at 10:00 AM Ben Rubinstein via use-livecode 
<use-livecode@lists.runrev.com <mailto:use-livecode@lists.runrev.com>> wrote:
    Hi Mike,
    Brian Milby put me on to the solution for the OAuth problem:
     > Check out bug 22557 / PR 7381.
     > Line 247 of oath2.livecodescript need urlEncode removed
    Are you still interested in this, or are you covered now?
    regards,
    Ben
    On 11/03/2020 20:45, Ben Rubinstein via use-livecode 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 <mailto: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
    <mailto: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 <mailto: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
    _______________________________________________
    use-livecode mailing list
    use-livecode@lists.runrev.com <mailto: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


_______________________________________________
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


_______________________________________________
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

Reply via email to