0

I am trying to automate some simple updating of a Google spreadsheet and I'm using the gspread library to do so. One task that is critical and not currently supported by gspread is the ability to add comments to a specific cell (there's an open issue for this and even a gist solution but I was getting a 404 error when trying to use it).

I know that the Google Drive API (v3) supports adding comments as described here, but I'm having issues with authenticating and could use some help.

What I have/know:

I have already setup the OAuth 2.0 and registered for the API through Google, as well as have the client_secret.json in my directory, but my knowledge of web requests and responses is limited so going through the Drive API documentation hardly makes sense. I know in order to create the comments I will have to make use of anchors and specify the cell location using column/row numbers.

What I'm stuck on:

When using the Google API Explorer, I'm getting a 400 error with the message: The 'fields' parameter is required for this method. How can I make the POST request using my authentication? I think from there I'd be able to actually add the comments myself.

Improve this question

1 Answer 1

Reset to default
1

I'm getting a 400 error with the message: The 'fields' parameter is required for this method

The error is asking for a property which you want returned (these properties are listed in Drive API files resource).

You can just place ' * ' to indicate you want it to return a complete response. That's the quick fix.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.