WiFiClientSecure and Google App Script

[bestpika]

I can't get any response.

WiFiClientSecure client;
...
if(client.connect("script.google.com", 443)) {
    client.println("POST /macros/s/.../exec HTTP/1.1");
    client.println("Host: script.google.com");
    client.println("Content-Type: application/x-www-form-urlencoded");
    client.println("Content-Length: 3");
    client.println();
    client.println("a=a");
    client.print("\r\n\r\n");
    while (!client.available()) { // loop forever
        delay(50);
        Serial.print(".");
    }
    while (client.available()) {
        char c = client.read();
        Serial.write(c);
    }
    client.stop();
}

[copercini]

I fixed this possible infinite loop here: https://github.com/espressif/arduino-esp32/pull/347/files#diff-78da625bea886a01b784f9d1563acf3aL90

But it's not merged yet

[electronicsguy]

@bestpika you won't get a direct response from google apps script since it uses redirection. Use this: HTTPSRedirect.

It works well on esp8266. I'll test it on ESP-32 and update. In case you test it and get any errors, please post them.

[bestpika]

@electronicsguy I can't get any response, so HTTPSRedirect not work, too.

[copercini]

@bestpika please enable Core Debug Level as verbose in your arduino IDE and post here

[electronicsguy]

@bestpika that probably indicates an error in the google apps scripts permissions. What settings is your we app published with?

[bestpika]

@electronicsguy anyone, even anonymous

[electronicsguy]

@bestpika You can use a service like hurl to test the webapp externally. Please see if that gives any response and errors, if any. Could you post the webapp URL here?

[bestpika]

If no post data, I can get response, but result is wrong.
If I send post data, I can't get any response.

But try https://www.hurl.it/, both can get response.

[me-no-dev]

What I can tell is that a=a is not url encoded, therefore the request is wrong. That value should be a%3Da

[me-no-dev]

but that could also be caused by wrong account data

[bestpika]

If app script no return, then not redirect.
I will change send data and try.

[bestpika]

I rewrite http request, then It is working okay.

void doSendThis() {
  Serial.println("Send...");
  if (client.connect(HOST, 443)) {
    String postData(String("gssid=") + GSSID + "&sheet=" + SHEET + "&value=" + "0|1|2");
    Serial.println(postData);
    client.println("POST " + String(PATH) + " HTTP/1.1");
    client.println("Host: " + String(HOST));
    client.println("Content-Type: application/x-www-form-urlencoded");
    client.println("Content-Length: " + String(postData.length()));
    client.println();
    client.println(postData);
    client.print("\r\n\r\n");
    Serial.println("Response...");
    while (!client.available()) {
      delay(100);
      Serial.print(".");
    }
    Serial.println();
    Serial.println("-----------");
    while (client.available()) {
      Serial.write(client.read());
    }
    Serial.println();
    Serial.println("-----------");
  }
  client.stop();
}

HTTP/1.1 200 OK
Content-Type: text/html; charset=utf-8
Cache-Control: no-cache, no-store, max-age=0, must-revalidate
Pragma: no-cache
Expires: Mon, 01 Jan 1990 00:00:00 GMT
Date: Fri, 12 May 2017 06:45:28 GMT
P3P: CP="This is not a P3P policy! See https://support.google.com/accounts/answer/151657?hl=en for more info."
P3P: CP="This is not a P3P policy! See https://support.google.com/accounts/answer/151657?hl=en for more info."
X-Content-Type-Options: nosniff
X-XSS-Protection: 1; mode=block
Server: GSE
Set-Cookie: ...
Set-Cookie: ...
Alt-Svc: quic=":443"; ma=2592000; v="37,36,35"
Accept-Ranges: none
Vary: Accept-Encoding
Transfer-Encoding: chunked

[swetapriyadarshi]

@bestpika
Hey i know this post is closed but still can u post the complete method of datalogging in google sheet as i am not able to do it.
Thanks

[workaholic2002x]

At last uploaded to Spreadsheet with esp-idf. But loosing 76 byte heap at every transaction. Any clue?