René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"\"Error! Not connected to host.\" when using ISR","articleBody":"Hey, \r\nI'm trying to create a kind of stopwatch and for the best responsibility, I use an interrupt, from which the subroutine to send the data is called.\r\n(When I was trying the raw example it worked and I used as much as I could from the example)\r\nAccording to the serial monitor, the values of my variables seem to be taken along correctly, but when the payload should get posted, it didn't work, and I got this response:\r\n```\r\nPublishing data...\r\n{\"command\": \"insert_row\", \"sheet_name\": \"Tabellenblatt1\", \"values\": \"4,406571,408355\"}\r\nError! Not connected to host.\r\nError while connecting\r\n```\r\nThis is my code: \r\n```\r\n#include \u003cArduino.h\u003e\r\n#include \u003cESP8266WiFi.h\u003e\r\n#include \"HTTPSRedirect.h\"\r\n\r\n#define ON_Board_LED 2\r\n#define BUTTON_PIN 0\r\n\r\nconst char* ssid     = \"myWiFi\";\r\nconst char* password = \"myPW\";\r\nconst char *GScriptId = \"my Script-ID\";\r\n\r\n// Enter command (insert_row or append_row) and your Google Sheets sheet name (default is Sheet1):\r\nString payload_base =  \"{\\\"command\\\": \\\"insert_row\\\", \\\"sheet_name\\\": \\\"Tabellenblatt1\\\", \\\"values\\\": \";\r\nString payload = \"\";\r\n\r\n// Google Sheets setup (do not edit)\r\nconst char* host = \"script.google.com\";\r\nconst int httpsPort = 443;\r\nconst char* fingerprint = \"\";\r\nString url = String(\"/macros/s/\") + GScriptId + \"/exec\";\r\nHTTPSRedirect* client = nullptr;\r\n\r\n// Declare variables that will be published to Google Sheets\r\nvolatile int run = 0;\r\nvolatile uint64_t time_start = 0;\r\nvolatile uint64_t time_finish = 0;\r\n\r\nvolatile bool running = false;\r\nvolatile uint64_t last_isr;\r\n\r\nvoid ICACHE_RAM_ATTR ISR() {\r\n  if (millis() - last_isr \u003e 500) { //bounce-filter\r\n    if (!running) {\r\n      time_start = millis();\r\n      running = true;\r\n      last_isr = millis();\r\n    } else {\r\n      time_finish = millis();\r\n      running = false;\r\n      run++;\r\n      last_isr = millis();\r\n      sendData(run, time_start, time_finish);\r\n    }\r\n  }\r\n}\r\n\r\nvoid setup() {\r\n  Serial.begin(9600);        \r\n  delay(10);\r\n  Serial.println('\\n');\r\n  \r\n  // Connect to WiFi\r\n  WiFi.begin(ssid, password);             \r\n  Serial.print(\"Connecting to \");\r\n  Serial.print(ssid); Serial.println(\" ...\");\r\n  while (WiFi.status() != WL_CONNECTED) {\r\n    delay(1000);\r\n    Serial.print(\".\");\r\n  }\r\n  Serial.println('\\n');\r\n  Serial.println(\"Connection established!\");  \r\n  Serial.print(\"IP address:\\t\");\r\n  Serial.println(WiFi.localIP());\r\n\r\n  // Use HTTPSRedirect class to create a new TLS connection\r\n  client = new HTTPSRedirect(httpsPort);\r\n  client-\u003esetInsecure();\r\n  client-\u003esetPrintResponseBody(true);\r\n  client-\u003esetContentTypeHeader(\"application/json\");\r\n  Serial.print(\"Connecting to \");\r\n  Serial.println(host);\r\n\r\n  // Try to connect for a maximum of 5 times\r\n  bool flag = false;\r\n  for (int i=0; i\u003c5; i++){ \r\n    int retval = client-\u003econnect(host, httpsPort);\r\n    if (retval == 1){\r\n       flag = true;\r\n       Serial.println(\"Connected\");\r\n       break;\r\n    }\r\n    else\r\n      Serial.println(\"Connection failed. Retrying...\");\r\n  }\r\n  if (!flag){\r\n    Serial.print(\"Could not connect to server: \");\r\n    Serial.println(host);\r\n    return;\r\n  }\r\n  delete client;    // delete HTTPSRedirect object\r\n  client = nullptr; // delete HTTPSRedirect object\r\n\r\n  pinMode(ON_Board_LED,OUTPUT); //--\u003e On Board LED port Direction output\r\n  digitalWrite(ON_Board_LED, HIGH); //--\u003e Turn off Led On Board\r\n  attachInterrupt(digitalPinToInterrupt(BUTTON_PIN), ISR, FALLING);\r\n}\r\n\r\nvoid loop() {\r\n  if (running) {\r\n    digitalWrite(ON_Board_LED, LOW);\r\n  } else {\r\n    digitalWrite(ON_Board_LED, HIGH);\r\n  }\r\n}\r\n\r\nvoid sendData(int run, uint64_t time_star, uint64_t time_finish) {\r\n  static bool flag = false;\r\n  if (!flag){\r\n    client = new HTTPSRedirect(httpsPort);\r\n    client-\u003esetInsecure();\r\n    flag = true;\r\n    client-\u003esetPrintResponseBody(true);\r\n    client-\u003esetContentTypeHeader(\"application/json\");\r\n  }\r\n  if (client != nullptr){\r\n    if (!client-\u003econnected()){\r\n      client-\u003econnect(host, httpsPort);\r\n    }\r\n  }\r\n  else{\r\n    Serial.println(\"Error creating client object!\");\r\n  }\r\n  \r\n  // Create json object string to send to Google Sheets\r\n  payload = payload_base + \"\\\"\" + run + \",\" + time_start + \",\" + time_finish + \"\\\"}\";\r\n  \r\n  // Publish data to Google Sheets\r\n  Serial.println(\"Publishing data...\");\r\n  Serial.println(payload);\r\n  if(client-\u003ePOST(url, host, payload)){ \r\n    // do stuff here if publish was successful\r\n  }\r\n  else{\r\n    // do stuff here if publish was not successful\r\n    Serial.println(\"Error while connecting\");\r\n  }\r\n}\r\n```\r\nI'm grateful for any advice on a better solution, thanks\r\n\r\nHardware: Wemos D1 mini","author":{"url":"https://github.com/franz134","@type":"Person","name":"franz134"},"datePublished":"2022-11-22T15:55:26.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":4},"url":"https://github.com/8/Google-Sheets-Logging/issues/8"}