search

jennybc / googlesheets

Google Spreadsheets R API
Other
783 stars 191 forks source link

Problem with encoding #381

Closed DavidGarciaEstaun closed 5 years ago

DavidGarciaEstaun commented 5 years ago

Hi,

This is my first time using this library and I am finding an issue. When I try to call gs_ls() or any other method, I am receiving this trace:

_Error in stop_for_contenttype(req, expected = "application/atom+xml; charset=UTF-8") : Expected content-type: application/atom+xml; charset=UTF-8 Actual content-type: text/html

Can anyone help me?

Thanks in advance.

jennybc commented 5 years ago

It's hard to say what the problem is, but it is probably not encoding. This just indicates that the error message is coming back as html (aimed at someone using the browser), not as xml (aimed at someone calling an API).

googlesheets is sort of (unofficially) retired, btw, and will be succeeded by googledrive (already on CRAN) + googlesheets4 (available on GitHub).

What are you trying to do?

DavidGarciaEstaun commented 5 years ago

Hi Jenny,

Thanks for your quick answer. What I need to do are daily updates in a Google Sheets document that is used as a data source in Data Studio (dashboard). I am going to review googlesheets4.

Thanks, David.

jennybc commented 5 years ago

Note that googlesheets4 can't write yet. Once I get gargle onto CRAN (it's submitted), I'll probably do an early read-only release of googlesheets4.

If you are willing to update the whole Sheet, googledrive can do this today. See drive_update().

And if you can explain more about your problem, there's probably a way to use googlesheets now. But I'd need a specific narrative + code about exactly what you're doing.

DavidGarciaEstaun commented 5 years ago

Hi Jenny,

Thanks for the information. I try to get the Google Sheets file with the drive_get() and read_sheet methods and later I append some info and upload it with the drive_update() method but I am receiving this error: _Error: Invalid dribble. These required column names are missing: name id driveresource

I am going to do some testing but I think it should work...

Regards.

jennybc commented 5 years ago

Again, these sorts of conversation are most productive when I can see exact code, in order of execution, and exact error messages.

But the above description of the error looks like you've added info to a data frame holding data to upload, but provided the data frame to drive_update() in a way that causes it to be interpreted as the dribble that specifies the target file id. It's impossible to say without seeing the code. I'm going to close this as it appears things are working or, even if not, your usage may be moving over to googledrive (not this package).