Can anybody point me to some simple example code to access Google Sheets from VFP?
I had some code a few months ago, but now that I actually need it, I can't find it again. <sigh>
Thx,
Fred
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
Sheets or streets?
Op di 9 mei 2017 om 19:51 schreef Fred Taylor fbtaylor@gmail.com
Can anybody point me to some simple example code to access Google Sheets from VFP?
I had some code a few months ago, but now that I actually need it, I can't find it again. <sigh>
Thx,
Fred
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
Sheets. I need to access Google's spreadsheet.
Fred
On Tue, May 9, 2017 at 1:30 PM, Koen Piller koen.piller@gmail.com wrote:
Sheets or streets?
Op di 9 mei 2017 om 19:51 schreef Fred Taylor fbtaylor@gmail.com
Can anybody point me to some simple example code to access Google Sheets from VFP?
I had some code a few months ago, but now that I actually need it, I
can't
find it again. <sigh>
Thx,
Fred
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
Fred:
Wow. That sounds like an interesting project! I know a little bit about Fox access to Microsoft Office, having spent a couple years writing some big automation apps (and editing a book) and automating OpenOffice (and writing a FoxTalk article), and doing a lot of work automating MSGraph, but I hadn't thought there'd be a way to do the Google Apps.
I've found instructions on setting up your Google Drive for offline access, which should give you local file access.
https://lifehacker.com/how-to-make-google-drive-work-like-a-desktop-suite-15...
And there's a Google Apps Scripting language: https://developers.google.com/apps-script/
But I'm not seeing the VFP-to-GApps interface. I don't think there's a COM, DCOM, or even DDE interface. I'm guessing you'd need to do something along the lines of HTTP Posts and Fetches using something like:
https://developers.google.com/apps-script/guides/services/external
Let me know if you find more info on this, as I could see this is something I'd like to work with, too.
On Tue, May 9, 2017 at 1:51 PM, Fred Taylor fbtaylor@gmail.com wrote:
Can anybody point me to some simple example code to access Google Sheets from VFP?
I had some code a few months ago, but now that I actually need it, I can't find it again. <sigh>
Thx,
Fred
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
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
On Tue, May 9, 2017 at 4:29 PM, Ted Roche tedroche@gmail.com wrote:
Fred:
Wow. That sounds like an interesting project! I know a little bit about Fox access to Microsoft Office, having spent a couple years writing some big automation apps (and editing a book) and automating OpenOffice (and writing a FoxTalk article), and doing a lot of work automating MSGraph, but I hadn't thought there'd be a way to do the Google Apps.
I've found instructions on setting up your Google Drive for offline access, which should give you local file access.
https://lifehacker.com/how-to-make-google-drive-work-like-a- desktop-suite-1557341520
And there's a Google Apps Scripting language: https://developers.google.com/apps-script/
But I'm not seeing the VFP-to-GApps interface. I don't think there's a COM, DCOM, or even DDE interface. I'm guessing you'd need to do something along the lines of HTTP Posts and Fetches using something like:
https://developers.google.com/apps-script/guides/services/external
Let me know if you find more info on this, as I could see this is something I'd like to work with, too.
On Tue, May 9, 2017 at 1:51 PM, Fred Taylor fbtaylor@gmail.com wrote:
Can anybody point me to some simple example code to access Google Sheets from VFP?
I had some code a few months ago, but now that I actually need it, I
can't
find it again. <sigh>
Thx,
Fred
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
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