Access the Google Sheets API for unsupported functionality
I tried to find out if this was possible in the documentation but didn't find anything so I guess this ticket could be either a documentation bug/shortcoming or if it's not actually possible, it could be a feature request, either for the ability to interact with the Sheets API from a gspread Client or even better, the ability to manipulate charts. Understanding that the former would be much simpler than the latter, so either is fine with me.
I want to do some Google Sheet manipulation that is not exposed by gspread. Specifically I want to update the Data Range of a chart.
Given that gspread does not have any support for charts, I presume I would need to use the Sheets API directly to do that.
So the question is [how] can I use the Sheets API directly with the Client object I have open with gspread assuming I knew the chart id already?
FWIW, I did try StackExchange for this question before opening this ticket but my question there was closed by a moderator, so it seems that Stack Exchange is not always a suitable to place to ask questions about gspread unfortunately.
hi ! thanks for the issue :]
we've just put gspread into maintenance mode since we took it over and no longer have enough time to maintain it :]
https://github.com/burnash/gspread/issues/1570
if you dig around in the code, you might find a way of using the Client object as you want :]
@brianjmurrell I do have a pull requests for charts #1575
@darkfiberiru Oh awesome. I'm going to add your PR to my local build here and give it a go. Thanks!