Get Google Spreadsheet with ethernet shield

Projects Programming
1

Hello,
I'm trying to get data from a google spreadsheet.
I'm working with this sketch.
It's run well with the json example: the data are displayed in my serial monitor.

If I replace the serverName by 'docs.google.com', and the GET line by

GET https://docs.google.com/spreadsheet/ccc?key=0AvadUPHGtvj_dE5DVjAxdzVVRWFKX201eDVlS2w4Wnc&usp=drive_web HTTP/1.1

, it doesn't work: I've this error:

HTTP/1.1 400 Bad Request

the real URL of my google doc is

https://docs.google.com/spreadsheet/ccc?key=0AvadUPHGtvj_dE5DVjAxdzVVRWFKX201eDVlS2w4Wnc&usp=drive_web#gid=0

I've tried with it too, but the result is the same.
This doc is a public document.
My GET line comes from web-sniffer.com

I didn't find any example of Google doc on the web.

Do you think it's possible ?

Thanks

2

The GET function does not take the protocol and server name as part of the request. That information is provided elsewhere.

The Ethernet shield does not have the necessary memory or processor power or speed to deal with the https protocol.

3

So I can't do it ?
:frowning:

I have to find how I can automatically and periodically export the google spreadsheet data in a web page.
I can't do it in a sites.google page because it's also a https protocol

4

So I can't do it ?

Not directly.

I have to find how I can automatically and periodically export the google spreadsheet data in a web page.
I can't do it in a sites.google page because it's also a https protocol

Set up your own server that the Arduino can talk to using http. Make that server talk to google using https.