Hello everybody,
I would like to save sensor values in a google spreadsheet to be able to call them up on the go (therefore no sdcard module, even if that would simplify a lot).
I have already created the "API" for this, a script that pays attention to parameters in a url, and then enters those in the spreedsheet. that already works, i.e. if I now open my url in the browser:
[u]https://mydomain.de?id=19&type=device&value=134[/u]
then everything (everything after the "?") get saved into the spreedsheet (see picture here)
now my problem: my esp does not want to load the website.
I tried 100th http or https clients example codes but it didn't work. Well, if I enter google as host, I get the entire source code from the google page, just as if I leave w3 school or other examples inside the example code of the http client, but as soon as I enter my url as host for the client, my serial monitor just prints "connection refushed", and I don't understand why.
[SETUP] WAIT 4...
[SETUP] WAIT 3...
[SETUP] WAIT 2...
[SETUP] WAIT 1...
[HTTPS] begin...
[HTTPS] GET...
[HTTPS] GET... failed, error: connection refused
Wait 10s before next round...
[HTTPS] begin...
[HTTPS] GE.*[HTTPS] GET... failed, error: connection refused
Wait 10s before next round...
As I said, I tried both the http client and the https client, and websites like w3 school or google can be queried and their website source code also ends up in my serial monitor, but the api website I created does not work and I understand it not at all.
PS: I would also like the website source code to be queried, because only if the parameters have been entered correctly, a "status: true" is displayed as an HTML code, and so my esp8266 can easily check whether the transfer was successful and if not, try agian until it works.
PSS: example code that can at least load the google page or w3school: (click to visit the code)
- Lynes