googleapis / googleapis/google-api-nodejs-client
Google sheet api valueRenderOption doesn't work properly
- Dominant language
- TypeScript
- Stars
- 12.2k
- Forks
- 2k
- Avg merge
- 1d 9h
- Merged PRs (30d)
- 24
Description
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
1. 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.
```ts
sheetsApi.spreadsheets.values.get({
spreadsheetId,
range,
valueRenderOption: 'FORMATTED_VALUE',
})
```
https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/get
Contributor guide
Assessment
This issue has not been assessed yet.