Dear Sir,
I used the following code to just post a value 32 into my google sheet , i just write a script , but nothing is showing to the google sheet....
#include <SoftwareSerial.h>
SoftwareSerial gprsSerial(2,3);
void setup()
{
gprsSerial.begin(2400);
Serial.begin(19200);
Serial.println("Config SIM900...");
delay(2000);
Serial.println("Done!...");
gprsSerial.flush();
Serial.flush();
// attach or detach from GPRS service
gprsSerial.println("AT+CGATT?");
delay(100);
toSerial();
// bearer settings
gprsSerial.println("AT+SAPBR=3,1,"CONTYPE","GPRS"");
delay(2000);
toSerial();
// bearer settings
gprsSerial.println("AT+SAPBR=3,1,"APN","airtelgprs.com"");
delay(2000);
toSerial();
// bearer settings
gprsSerial.println("AT+SAPBR=1,1");
delay(2000);
toSerial();
}
void loop()
{
// initialize http service
gprsSerial.println("AT+HTTPINIT");
delay(2000);
toSerial();
// set http param value
gprsSerial.println("AT+HTTPPARA="URL",\https://script.google.com/macros/s/AKfycbxY4uR1O3HhOY50EcJ8NpbAMuRVDtNAkUEKwt0fafdkNybxf40/exec?32");
delay(2000);
toSerial();
// set http action type 0 = GET, 1 = POST, 2 = HEAD
gprsSerial.println("AT+HTTPACTION=0");
delay(6000);
toSerial();
// read server response
gprsSerial.println("AT+HTTPREAD");
delay(1000);
toSerial();
gprsSerial.println("");
gprsSerial.println("AT+HTTPTERM");
toSerial();
delay(300);
gprsSerial.println("");
delay(10000);
}
void toSerial()
{
while(gprsSerial.available()!=0)
{
Serial.write(gprsSerial.read());
}
}
am getting the serial outputs as follows....
Config SIM900...
Done!...
AT+CGATT?
AT+SAPBR=3,1,"CONTYPE","GPRS"
+CGATT: 1
OK
AT+SAPBR=3,1,"APN","airtelgprs.com"
OK
AT+SAPBR=1,1
ERROR
AT+HTTPINIT
ERROR
AT+HTTPPARA="URL",https://script.google.com/macros/s/AKfycbxY4uAT+HTTPACTION=0
OK
+HTTPACTION:0,603,0
AT+HTTPREAD
OK
AT+HTTPTERM
OK
AT+HTTPINIT
OK
AT+HTTPPARA="URL",https://script.google.com/macros/s/AKfycbxY4uAT+HTTPACTION=0
OK
+HTTPACTION:0,603,0
AT+HTTPREAD
OK
AT+HTTPTERM
OK
AT+HTTPINIT
OK
AT+HTTPPARA="URL",https://script.google.com/macros/s/AKfycbxY4uAT+HTTPACTION=0
OK
+HTTPACTION:0,603,0
AT+HTTPREAD
OK
AT+HTTPTERM
OK
AT+HTTPINIT
OK
AT+HTTPPARA="URL",https://script.google.com/macros/s/AKfycbxY4uAT+HTTPACTION=0
OK
+HTTPACTION:0,603,0
AT+HTTPREAD
OK
AT+HTTPTERM
OK
AT+HTTPINIT
OK
AT+HTTPPARA="URL",https://script.google.com/macros/s/AKfycbxY4uAT+HTTPACTION=0
OK
AT+HTTPREAD
OK
+HTTPACTION:0,603,0
AT+HTTPTERM
OK
AT+HTTPINIT
OK
AT+HTTPPARA="URL",https://script.google.com/macros/s/AKfycbxY4uAT+HTTPACTION=0
OK
+HTTPACTION:0,603,0
AT+HTTPREAD
OK
Please help me to solve the issue,
Ajin nadh v a