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: FourthWorld, heatherlaine, Klaus, kevinmiller

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

Retrieving rows from google spreadsheet

Post by teacherguy » Thu Dec 08, 2011 2:46 am

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

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

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

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

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