google spreadsheet API login woes

[Bob MacCallum]

Thanks Steve and Simon,

It looks like the days of running a simple script against Google services
authorised by just username and password are long gone.

The beauty of my spreadsheet file grabber was that anyone could use it
without registering API keys etc and also that it only took half an hour to
write!



On Thu, Oct 16, 2014 at 6:28 PM, Steve Mynott <steve.mynott at gmail.com>
wrote:

> On 16 October 2014 16:59, Simon Wistow <simon at thegestalt.org> wrote:
> > On Thu, Oct 16, 2014 at 12:35:18PM +0100, Bob MacCallum said:
> >> It's stopped working recently (can't say exactly when) - and I don't
> know
> >> my AuthSub from my OAuth from my elbow.
> >>
> >> I've tried
> >>
> >>     my $auth = Net::Google::AuthSub->new;
> >>     my $res  = $auth->login($user, $pass);
> >
> > I wrote Net::Google::AuthSub but I haven't used it for years and so it
> > may be very, very out of date.
>
> It didn't seem to work when I tried it a few weeks back despite
> Google's claims of AuthSub being still supported until next year.
> They probably changed something.  It's all very geared to their own
> API libs not 3rd party ones for unsupported languages like Perl.
> AuthSub is deprecated in favour of OAuth (which is pretty dreadful as
> demonstrated by the YAPC::EU Oauth Dance).
>
> I successfully accessed Google Calendar last month with a lot of
> difficulty by doing the following:
>
> Google::API::Client via  git clone
> https://github.com/comewalk/google-api-perl-client.git
>
> Used https://console.developers.google.com/project  (different to the
> similarly named Google Play one!)
>
> Note this does not work and doesn't give any warnings of not working
> in a Firefox type browser I had to use Chrome.
>
> I had to google several errors on stackoverflow (and noticed assorted
> whines) to get the exact workflow in the dev console correct.
>
> APIs & Auth>
>
> 1. Google Calender ON
>
> 2. Cred>Create new client ID> Installed Application
>
> 3. Also enter Email Address and minimal details in Consent Screen
>
> $ cd google-api-perl-client/eg
>
> edit "client_secrets.json" with your "client_id"
>
> $ cd calendar
>
> $ perl -I ../lib/ calendarlist.pl
>
> Click on URI generated (I again had problems with Firefox and had to
> use Chrome in order to copy and paste)
>
> copy auth token back to command line
>
> (this token is saved in the json and next time you run you aren't
> prompted with url).
>
> I was then able to access Google Calendar.
>
> It's sure to time out and you probably have to refresh it.
>
> I'd probably avoid Google Services after this experience unless I was
> being paid to do it.  It's aimed at professional phone app devs not
> hobbyist use.
>
> I suspect it changes quite frequently too.
>
> S
>