search

appsmithorg / appsmith

Platform to build admin panels, internal tools, and dashboards. Integrates with 25+ databases and any API.
https://www.appsmith.com
Apache License 2.0
34.67k stars 3.75k forks source link

[Bug]-[120]:Incorrect response from Google sheets API #19465

Open Vidushi-Gupta opened 1 year ago

Vidushi-Gupta commented 1 year ago

Is there an existing issue for this?

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' image The API returns the following: image

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 commented 1 year ago

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

20230103114212 20230103114236

Irongade commented 1 year ago

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

Stats

Stat Values
Reach 120
Effort (months) 0.5
rohan-arthur commented 1 year ago

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