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 <[email protected]> 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 <[email protected]> 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] _______________________________________________ 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/cajcbksoa583r6-zqvqhlo6d_idqumbpfzrq1kc3t5qecv+y...@mail.gmail.com ** 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.
