AT commands for thingspeak and restdb.io

[ubttom1965]

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

[esp-at]

Before you send AT+CIPSTART command, could you please try to configure SNI, and then test.

AT+CIPSSLCSNI="dbtemp1-XXXX.restdb.io"

[esp-at]

If you can provide the test url, i would like to look into it.

[ubttom1965]

Thanks,

but it makes no difference.

[esp-at]

as a compare, you can use `curl` tool to test if it works, and then construct same http headers as the `curl` did.