Nevermind. Turns out it is a serious bug in retool, where file is not at all uploaded at all to drive if you upload it, turns out there is some issue in how it handles file upload. Switched to a native react web application and it works fine now.
Hey @SHC! Welcome to the community and thanks for reaching out!
What kind of file are you trying to upload and how have you configured the request? I agree that Google's documentation for the HTTP REST API is a bit lacking, but I played around with it for a bit and got it to work.
For me, it worked best to configure a multipart request and to format the RAW body manually.
I am having myself a problem with G Drive API.
I tried various ways and just tested the solution you proposed.
I still get "Unsupported content with type: application/octet-stream"
No matter what I see the body in request being wrapped in " " and I can't send it as an object, it's always a string.
Depending on where you're inspecting the body of the request, I actually expect it to be formatted as a string - especially if you're doing a multipart upload. Can you share the configuration that isn't working for you?