search

jennybc / googlesheets

Google Spreadsheets R API
Other
783 stars 191 forks source link

gs_edit_cells #364

Closed cal65 closed 2 years ago

cal65 commented 6 years ago

As of 2022-02-03, the googlesheets package has been archived on CRAN. I'm closing all issues and pull requests prior to archiving this GitHub repo.

Learn more at:

https://github.com/jennybc/googlesheets#readme

jennybc commented 6 years ago

Not sure but here's more about what 409 means:

    409,             "ABORTED", "Concurrency conflict, such as read-modify-write conflict.",
    409,      "ALREADY_EXISTS", "The resource that a client tried to create already exists.",

so it could be a problem of making separate requests too soon after each other and one request is still "wrapping up" when the next one comes in.

oguzhanogreden commented 5 years ago

I had the same problem and I was also able to repeat it in a debugging session. The 'trick' in that session seemed to be using gs_title('Test Sheet') in each iteration of a loop rather than calling sheet <- gs_title('Test Sheet') once and then using sheet %>% gs_edit_cells(...).

I wanted to note this here and I will try to produce a MWE some time soon.