AT commands for thingspeak and restdb.io
Posted: Mon Jun 16, 2025 11:15 am
Hey,
i have a question about thingspeak and restdb.io
that are databases for iot with a rest api interface over HTTP.
My HW is ESP32-C6-DevKitC-1 and/or ESP8266, communication ONYL over AT-commands
and the serial interface of the ESP.
The ESP worked as Station( Mode=1) and is logged in at an Accesspoint.
AT commands work with thingspeak and with restdb.io i can connect with the server
but i get no answer for my GET command.
Her is the flow for thingspeak, that works, i get a connection with the server:
AT+CIPSTART="TCP","api.thingspeak.com",80
CONNECT
OK
AT+CIPSEND=63
OK
>
then i send the GET command
GET /channels/1030392/fields/1/2.txt?api_key=XXXXXXXXXXXXXXXX //with CR + LF
Recv 63 bytes
SEND OK
this is what i get from thingspeak, that is OK and the connection ist closed:
+IPD,65:{"created_at":"2022-06-30T10:23:27Z","entry_id":2,"field1":"200"}
CLOSED
if i try it with restdb.io, i do it in the same manner:
i tested also with "TCP and port 80
AT+CIPSTART="SSL","dbtemp1-XXXX.restdb.io",443
CONNECT
OK
AT+CIPSEND=65
OK
>
then i send this :
GET /rest/device1?&apikey=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX //also with CR and LF
Recv 65 bytes
SEND OK
CLOSED
between SEND OK and CLOSED pass away 60sec. and i get nothing back.
If i do it in my browser(firefox) i get back my records from restdb.io
but not with the AT-commands.
Have someone any advice or hints for me.
Thanks Tom
i have a question about thingspeak and restdb.io
that are databases for iot with a rest api interface over HTTP.
My HW is ESP32-C6-DevKitC-1 and/or ESP8266, communication ONYL over AT-commands
and the serial interface of the ESP.
The ESP worked as Station( Mode=1) and is logged in at an Accesspoint.
AT commands work with thingspeak and with restdb.io i can connect with the server
but i get no answer for my GET command.
Her is the flow for thingspeak, that works, i get a connection with the server:
AT+CIPSTART="TCP","api.thingspeak.com",80
CONNECT
OK
AT+CIPSEND=63
OK
>
then i send the GET command
GET /channels/1030392/fields/1/2.txt?api_key=XXXXXXXXXXXXXXXX //with CR + LF
Recv 63 bytes
SEND OK
this is what i get from thingspeak, that is OK and the connection ist closed:
+IPD,65:{"created_at":"2022-06-30T10:23:27Z","entry_id":2,"field1":"200"}
CLOSED
if i try it with restdb.io, i do it in the same manner:
i tested also with "TCP and port 80
AT+CIPSTART="SSL","dbtemp1-XXXX.restdb.io",443
CONNECT
OK
AT+CIPSEND=65
OK
>
then i send this :
GET /rest/device1?&apikey=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX //also with CR and LF
Recv 65 bytes
SEND OK
CLOSED
between SEND OK and CLOSED pass away 60sec. and i get nothing back.
If i do it in my browser(firefox) i get back my records from restdb.io
but not with the AT-commands.
Have someone any advice or hints for me.
Thanks Tom