Google sheet api valueRenderOption doesn't work properly - Githubissues

googleapis / google-api-nodejs-client

Google's officially supported Node.js client library for accessing Google APIs. Support for authorization and authentication with OAuth 2.0, API Keys and JWT (Service Tokens) is included.

https://googleapis.dev/nodejs/googleapis/latest/

Apache License 2.0

11.27k stars 1.91k forks source link

Google sheet api valueRenderOption doesn't work properly #3384

Open Chathula opened 8 months ago

Chathula commented 8 months ago

1) Is this a client library issue or a product issue?

It looks like the library issue as it works fine with product direct API

2) Did someone already solve this?

No 3) Do you have a support contract?
No

Environment details

OS: Mac
Node.js version: v18.16.0
npm version: 9.5.1
googleapis version: 128.0.0

Steps to reproduce

I tried to fetch spreadsheet values using the below method. but it returns numeric values as it is, when I use the google API Explorer, it returns all the values as strings. I want to get all the values as strings in this case.
```
sheetsApi.spreadsheets.values.get({
        spreadsheetId,
        range,
        valueRenderOption: 'FORMATTED_VALUE',
    })
```

https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/get