[Bug]: Incorrect response from Google sheets API

[Vidushi-Gupta]

Is there an existing issue for this?

• [X] I have searched the existing issues

Description

If values in a google sheet column start with null, the API returns null values for all the rows

For example: The values of a column start with null in the column 'Medium' The API returns the following:

The expected response should be: [ { "Medium": "", "rowIndex": 0 }, { "Medium": "direct", "rowIndex": 1 }, { "Medium": "direct_mail", "rowIndex": 2 }, { "Medium": "display", "rowIndex": 3 },

Steps To Reproduce

1. Create a google sheet with a column that has values starting with null
2. Connect the google sheet data source in an appsmith app
3. Create an API and using the Fetch Many operation, fetch the values of the column

Public Sample App

No response

Issue video log

No response

Version

Cloud - v1.8.16-SNAPSHOT

[felix-appsmith]

I was able to reproduce this. In my test, it happens when the first value is null

[Irongade]

Number of users in 6m: 2401. Estimated reach percentage: 5%

Stats

Stat	Values
Reach	120
Effort (months)	0.5

[rohan-arthur]

checked on 15 Aug 2023, still reproducible. But keeping the priority as Low considering this looks like a rare use case.