ESP8266 Community Forum

- Thu May 03, 2018 8:08 am #75736 Hello! I've been trying to post data on my google sheet with an XMEGA but I keep getting this error "POST requests require a <code>Content-length</code>" Can somebody help me?

AT+CIPSTART="TCP","sheets.googleapis.com",80

AT+CIPSEND=462
POST /v4/spreadsheets/1IIUYggTRVpAvd6cuqt38HODdUFKVMntZqtYdDxZKlw8/values/ROBOT!A1:D5?valueInputOption=USER_ENTERED
Host: sheets.googleapis.com
Content-Length: 269
Content-Type: text/xml

{"range": "Sheet1!A1:D5","majorDimension": "ROWS","values": [["Item", "Cost", "Stocked", "Ship Date"],["Wheel", "$20.50", "4", "3/1/2016"],["Door", "$15", "2", "3/15/2016"],["Engine", "$100", "1", "30/20/2016"],["Totals", "=SUM(B2:B4)", "=SUM(C2:C4)", "=MAX(D2:D4)"]],}

- Fri May 04, 2018 3:23 am #75755 Haven't you asked this question earlier this week?
Was my answer not adequate enough or did it need more clarification?
There's no need to double- or cross-post...

Assumption is the mother of all f*ckups. At least: that's what I'm assuming.

- Fri May 04, 2018 4:17 am #75759

Hello! I've been trying to post data on my google sheet with an XMEGA but I keep getting this error "POST requests require a <code>Content-length</code>" Can somebody help me?

AT+CIPSTART="TCP","sheets.googleapis.com",80

AT+CIPSEND=462
POST /v4/spreadsheets/1IIUYggTRVpAvd6cuqt38HODdUFKVMntZqtYdDxZKlw8/values/ROBOT!A1:D5?valueInputOption=USER_ENTERED
Host: sheets.googleapis.com
Content-Length: 269
Content-Type: text/xml

{"range": "Sheet1!A1:D5","majorDimension": "ROWS","values": [["Item", "Cost", "Stocked", "Ship Date"],["Wheel", "$20.50", "4", "3/1/2016"],["Door", "$15", "2", "3/15/2016"],["Engine", "$100", "1", "30/20/2016"],["Totals", "=SUM(B2:B4)", "=SUM(C2:C4)", "=MAX(D2:D4)"]],}

I've said it on other posts, and I'll say it again here - this is to do with 'the web' : specific 3rd party protocol/interaction (in this case trying to 'speak' so google sheets understands you).
This has nothing to do with the esp8266; it has nothing to do with this forum.

It's like asking a forum dedicated to telephones to solve the problem of your inability to speak Chinese/Mandarin when phoning someone in China.

- Sun May 06, 2018 7:18 pm #75807

Hello! I've been trying to post data on my google sheet with an XMEGA but I keep getting this error "POST requests require a <code>Content-length</code>" Can somebody help me?

AT+CIPSTART="TCP","sheets.googleapis.com",80

AT+CIPSEND=462
POST /v4/spreadsheets/1IIUYggTRVpAvd6cuqt38HODdUFKVMntZqtYdDxZKlw8/values/ROBOT!A1:D5?valueInputOption=USER_ENTERED
Host: sheets.googleapis.com
Content-Length: 269
Content-Type: text/xml

{"range": "Sheet1!A1:D5","majorDimension": "ROWS","values": [["Item", "Cost", "Stocked", "Ship Date"],["Wheel", "$20.50", "4", "3/1/2016"],["Door", "$15", "2", "3/15/2016"],["Engine", "$100", "1", "30/20/2016"],["Totals", "=SUM(B2:B4)", "=SUM(C2:C4)", "=MAX(D2:D4)"]],}

I've said it on other posts, and I'll say it again here - this is to do with 'the web' : specific 3rd party protocol/interaction (in this case trying to 'speak' so google sheets understands you).
This has nothing to do with the esp8266; it has nothing to do with this forum.

It's like asking a forum dedicated to telephones to solve the problem of your inability to speak Chinese/Mandarin when phoning someone in China.

Where should I post it then?