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 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
