LiveCode Forums.

So, recently I ran into errors with certificates when trying to GET data from a google spreadsheet.

Reading the forum, I saw that some had to put this before their GET statement:

libURLSetSSLVerification false

So I did that, and indeed I could now get the data when in the IDE and even when in a standalone provided there was no splash stack. But when I build with a splash stack, the GET errors again.

Update: Not an error, EMPTY. Strange.

Did you add the LIBURL to your SPLASH standalone stack?
Sounds like you didn't.

Klaus wrote:Did you add the LIBURL to your SPLASH standalone stack?
Sounds like you didn't.

So I place this into the splash?
Does it matter where?

Hi,

no, I meant, did you add/check the "Internet" library in the standalone builder for your splash stack/standalone?
Leave your scripts as they are.


Best

Klaus

Oh, well looks like time for another lesson for the newbie... what is this library you speak of?

I looked at the settings for my main stack (which creates a standalone that works) and it appears identical to my splash settings.

Hi,

teacherguy wrote:Oh, well looks like time for another lesson for the newbie... what is this library you speak of?

well, as the name suggests, this provides all the LIBURLxxx commands and functions like "libURLSetSSLVerification false".

teacherguy wrote:I looked at the settings for my main stack (which creates a standalone that works) and it appears identical to my splash settings.

OK, so you checked "Internet" in the standalone builder on the "General" tab?
If you did, we can only guess what might go wrong on your side...


Best

Klaus

Ah I see thank you. So "Internet" was included under general in my main stack, but not in the splash. So I highlighted it, and built again, but no change. That certainly seemed like it would have been the obvious fix.

I think I've got it, have to do a few more tests. So I was thinking "it's not giving me an error, it's returning empty. So maybe it's just not done."

So I inserted:
And it seems to be OK thus far.

Hmm, very strange, but good you got it working

It is still inconsistent, I'm convinced that it has something to do with how long it takes to get the data back from google. I'll keep at it.