Page 1 of 1
Using Google Spreadsheets - Trouble with URL encoding
Posted: Mon May 11, 2009 1:28 am
by acidjazz
I'm trying to figure out how to communicate with Google Spreadsheets via Revolution and the Spreadsheets API. Haven't gotten too far. Here is what I'm reading in the Account Authentication API section.
http://code.google.com/apis/accounts/do ... dApps.html
The first example illustrates a basic login request. This example is shown not URL-encoded for clarity.
POST /accounts/ClientLogin HTTP/1.0
Content-type: application/x-www-form-urlencoded
accountType=HOSTED_OR_GOOGLE&Email=
jondoe@gmail.com&Passwd=north23AZ&service=cl&
source=Gulp-CalGulp-1.05
My question is simply, what WOULD it look like if it were URL encoded? What do I type into my script?
Thanks,
Mark P.
Posted: Mon May 11, 2009 2:59 am
by mwieder
If you open the messagebox and type
Code: Select all
put urlencode("accountType=HOSTED_OR_GOOGLE&Email=jondoe@gmail.com&Passwd=north23AZ&service=cl&source=Gulp-CalGulp-1.05")
you get
Code: Select all
accountType%3DHOSTED_OR_GOOGLE%26Email%3Djondoe%40gmail.com%26Passwd%3Dnorth23AZ%26service%3Dcl%26source%3DGulp-CalGulp-1.05
That get you what you need?
Posted: Mon May 11, 2009 4:17 am
by acidjazz
Yes, and I'm too embarrassed to tell you what I *wasn't* understanding earlier . But, now I do. Thanks very much!
Mark
Posted: Mon May 11, 2009 4:53 am
by mwieder
No problem <g>
Posted: Mon May 11, 2009 5:29 am
by acidjazz
Unfortunately it now appears that because I do not have the Enterprise version of Revolution, I cannot access google datasets because they require the http
s (SSL) protocol. Trying to do so using Revolution Studio gets you an "error socket closed" message
Mark
Re:
Posted: Fri Apr 29, 2011 7:56 pm
by neo42
acidjazz wrote:Unfortunately it now appears that because I do not have the Enterprise version of Revolution, I cannot access google datasets because they require the http
s (SSL) protocol. Trying to do so using Revolution Studio gets you an "error socket closed" message
Mark
I have livecode 4.6 commercial license. I think I can probably use HTTPS. How do you sign into an SSL account from livecode?