Page 1 of 1

Retrieving rows from google spreadsheet

Posted: Thu Dec 08, 2011 2:46 am
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?

Re: Retrieving rows from google spreadsheet

Posted: Thu Dec 08, 2011 10:50 pm
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.

Re: Retrieving rows from google spreadsheet

Posted: Thu Dec 08, 2011 11:17 pm
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

Re: Retrieving rows from google spreadsheet

Posted: Thu Dec 08, 2011 11:22 pm
by teacherguy
Thanks for the advice Mark. I had tried that but the result is the same unfortunately.

Re: Retrieving rows from google spreadsheet

Posted: Fri Dec 09, 2011 1:30 am
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