I am a newbie in Arduino and i am currently doing a project on development of a cloud-based Automatic Data Collection for Internet of Things Apps and i did my codes through Temboo.
My question is, once we get the codes from Temboo for passing sensor data to Arduino, are we allowed to exit the page? I did edit my codes so that it can read my sensor for temperature, it did upload to my arduino but the problem is it prompted error on the serial monitor and there was nothing on my spreadsheets. The error was:
Shield:OK
WiFi:OK
Setup complete.
Running AppendValues - Run #1
HTTP_CODE
500
Server Error
content-type: text/plain
Date: Wed, 02 Nov 2016 09:48:33 GMT
Server: Jetty(8.1.7.v20120910)
Vary: Accept-Encoding
Content-Length: 384
Connection: close
Error
A Step Error has occurred: "A HTTP Error has occurred: The remote server responded with a status code of 400. Typically this indicates that the request was malformed. The data returned from the remote server was: {
"error" : "invalid_grant"
}. The error occurred in the HTTPSend (Google - refresh token) step.". The error occurred in the LaunchChoreo (RefreshToken) step.
Waiting...
A/D units volts degrees F
It keeps on running AppendValues but nothing was shown in my spreadsheet.
Please advice and thank you in advance!
Yes, you can certainly leave a Choreo page once you've generated and downloaded the code you need or recorded the API response you wanted.
The error you've included in your question above suggests that the client ID you're trying to use is incorrect. It's possible that you've copy/pasted the client ID from the Google app dashboard and introduced some invisible white space at the end of the ID. Please double check that you have the ID exactly as Google gave it to you and try again.
If you need to review the setup instructions for the Google OAuth choreos, you can find them on this page:
There's also a chance that your access token has expired. Access tokens have a relatively short life, so try supplying a refresh token instead. Here's why: if you supply a refresh token as an input to your Google Sheets AppendValues Choreo, your application will automatically get a new access token each time your last access token expires. You can get a refresh token from the second step of OAuth, FinalizeOAuth. Again, the link above has all the steps you'll need to complete the process successfully.
Hopefully that answers your question! If you're still having issues, feel free to contact us via the support form on this page:
My client ID was okay, i think the problem here is my access token has expired.
I have completed the process successfully. I did run the codes they gave me at Arduino and it works perfectly but after a few hours, that error was given. It was still able to run, except that the error will show maybe due to my refresh token. Is there any other alternative i can do? Thanks!
If using a refresh token hasn't solved the issue, I think we could help you get to the bottom of it a bit better if you send a note to our support team along with your current code to support@temboo.com. That way we can see whether you're using the correct inputs without exposing your credentials online.