Fred Taylor wrote on 2017-05-10:
Hi Ted,
Yeah, it was a lot of http POSTs and GETs, using the API, but the tricky part was getting through the authorization.
I've done a lot of Excel automation myself, but this is way more
involved.
All I'm trying to do is periodically add some rows from a VFP table to
the
Google Sheets app in the browser. If Excel didn't suck so badly in multi-user access, we'd use it. The Google Docs apps seem to work very well in that kind of environment. We have a "dashboard" like spreadsheet in the browser that we have users accessing both from here in AZ and a
few
in OH.
Wish I could find that example code again.
Fred
Fred,
Authentication can be handled one of two ways. 1) You capture the redirect in the embedded browser control. 2) You set up a server that will capture the redirect, then query that from you program.
I used the C# library for the Calendar API some years ago. It used the Chromium browser to capture the redirect.
The environment I need to program for has IE locked down. This blocked the embedded IE browser ActiveX control.
For a similar oAuth token request, I did write a C# service to capture the redirect. This allowed me to use the default browser on the client machine.
HTH, Tracy
Tracy Pearson PowerChurch Software