Retrieving rows from google spreadsheet

Got a LiveCode personal license? Are you a beginner, hobbyist or educator that's new to LiveCode? This forum is the place to go for help getting started. Welcome!

Moderators: Klaus, FourthWorld, heatherlaine, kevinmiller

Post Reply
teacherguy
Posts: 379
Joined: Thu Dec 08, 2011 2:43 am

Retrieving rows from google spreadsheet

Post by teacherguy »

Hello all, thank you for your time. I did a lot of reading and searching on the forum tonight and found great threads on how to submit google forms, and that works great. But I am unable to find help in how to retrieve rows from the resulting spreadsheet to bring back into my stack at various times.

Would anyone be willing to advise?
teacherguy
Posts: 379
Joined: Thu Dec 08, 2011 2:43 am

Re: Retrieving rows from google spreadsheet

Post by teacherguy »

This is the result I am getting when I try to access my spreadsheet:

An error occurred: error Error loading CA file and/or directory /usr/share/curl/curl-ca-bundle.crt.
Mark
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 5150
Joined: Thu Feb 23, 2006 9:24 pm
Contact:

Re: Retrieving rows from google spreadsheet

Post by Mark »

Hi,

I never did this myself, but I know this is possible and you need to read the API documentation. Try using

Code: Select all

libUrlSetSSLVerification false
to avoid the error.

Best,

Mark
The biggest LiveCode group on Facebook: https://www.facebook.com/groups/livecode.developers
The book "Programming LiveCode for the Real Beginner"! Get it here! http://tinyurl.com/book-livecode
teacherguy
Posts: 379
Joined: Thu Dec 08, 2011 2:43 am

Re: Retrieving rows from google spreadsheet

Post by teacherguy »

Thanks for the advice Mark. I had tried that but the result is the same unfortunately.
teacherguy
Posts: 379
Joined: Thu Dec 08, 2011 2:43 am

Re: Retrieving rows from google spreadsheet

Post by teacherguy »

Making great progress based on a post at blog (dot) ouseful (dot) info. I would post the link but I cannot yet.... ah, the life of a forum newbie. :D
Post Reply