Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Data only posting 4 times #16

Open
BigBillTolbert opened this issue Dec 3, 2024 · 1 comment
Open

Data only posting 4 times #16

BigBillTolbert opened this issue Dec 3, 2024 · 1 comment

Comments

@BigBillTolbert
Copy link

I got everything set up or so I think so. What is weird is I get an error message (Error while connecting) and yet a row is posted into the spreadsheet. Then It does that four times and then I get an additional error (Error! Not connected to host.) and no posting to the spreadsheet.

Is there some sort of limiter on the API that would disconnect me if they posts are too close together?

Here is the serial output:

Connection established!
IP address: 192.168.4.89
Connecting to script.google.com
Connected
Publishing data...
{"command": "insert_row", "sheet_name": "Sheet1", "values": "1,890,51422"}
Error while connecting
Publishing data...
{"command": "insert_row", "sheet_name": "Sheet1", "values": "2,12,17691"}
Error while connecting
Publishing data...
{"command": "insert_row", "sheet_name": "Sheet1", "values": "3,809,22357"}
Error while connecting
Publishing data...
{"command": "insert_row", "sheet_name": "Sheet1", "values": "4,399,66705"}
Connection to re-directed URL failed!
Error while connecting
Publishing data...
{"command": "insert_row", "sheet_name": "Sheet1", "values": "5,65,15800"}
Error! Not connected to host.
Error while connecting
Publishing data...
{"command": "insert_row", "sheet_name": "Sheet1", "values": "6,546,78424"}
Error! Not connected to host.
Error while connecting
Publishing data...
{"command": "insert_row", "sheet_name": "Sheet1", "values": "7,716,25744"}
Error! Not connected to host.
Error while connecting
Publishing data...
{"command": "insert_row", "sheet_name": "Sheet1", "values": "8,289,47307"}
Error! Not connected to host.
Error while connecting

@StorageB
Copy link
Owner

StorageB commented Dec 5, 2024

How frequent are you publishing to Google sheets? Not exactly sure why, but I have noticed if you're trying to connect too often it will not work correctly. I believe it was recommended by the author of the
HTTPSRedirect library used in this tutorial to wait 4 or 5 seconds between each publishing attempt.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants