search

jennybc / googlesheets

Google Spreadsheets R API
Other
783 stars 191 forks source link

Endless loop of accessing sheets #365

Closed brookezkeene closed 6 years ago

brookezkeene commented 6 years ago

I have been using gs_title then gs_read_csv to access two Google Sheets at the beginning of my ui.R code.

screen shot 2018-07-02 at 12 09 59 pm

This has been working perfectly up until now. For some reason, now my code keeps trying to access these two sheets until it hits a Too Many Requests error. Do you have any idea why this may be happening?

screen shot 2018-07-02 at 12 06 58 pm
jennybc commented 6 years ago

I don't know but I suspect the Shiny aspect of this is your best lead, as that is the most likely culprit re: a non-obvious reason for re-executing the code. I can't think of anything in googlesheets that can do this.

brookezkeene commented 6 years ago

Ok, thank you for your help!

jennybc commented 6 years ago

I'm going to close this but you're welcome to come back if you establish a root cause in the googlesheets package.