Fix issue with google sheets API

Job ID: 31810767

Budget: $10 – $30 USD

Hi I have a problem with google sheets API described here

https://stackoverflow.com/questions/69537680/how-to-get-raw-numbers-from-google-sheets-api

And to recap:
I have a simple function that gets data from a google sheet.

for example https://sheets.googleapis.com/v4/spreadsheets/1pSQ4W0GV85Z-6QrUx0UxVA3VCSHE3x93BT3c-R6mHZk/values/Form Responses 1!A1:AZ1000?valueRenderOption=UNFORMATTED_VALUE

I have a field there with long numbers, that google automatically displays in scientific notation like this

{
"range": "'Form Responses 1'!A1:F103",
"majorDimension": "ROWS",
"values": [
[
"cc"
],
[
4.3668413379866e+15
],
[
4.14809933325943e+15
]
]
}

I don't mind how its displayed in Sheets, as its never used directly. But in my API call I must be able to get the original/raw number.

PS. Changing the format in the sheets ui might help, but this has 2 issues:

It will require double and triple work for each field in each sheet, instead of fixing in the code that gets the data.
I tried it for testing, but it seems to ruin existing data, by changing also the raw "data-behind". Instead of only the display value. So I can't go that route anyway.

What I need from you:
.net code that gets the spreadsheet data with the correct number values, without scientific notation formatting. or any other formatting for that matter.

Thanks!
Related categories: Google APIs