Hi, I am trying to import my google sheets into appsmith but some data points have missing values. I do not know what is causing it. Any help is appreciated!
#Google sheets API call issue
tiny glacier
To give some context, there are other rows with the number 0 in this datafields that are not showing up. This is to indicate a null value.
old drumBOT
@tiny glacier can you please confirm if this is happening only for that
one particular row or all the other rows? Just speculating at this point, but I
think the system is omitting the property because it is set to 0. If that's
the case we should file a bug.
tiny glacier
Hi, the data is missing whenever the cell is any value other than 0. I will show you a few other rows as example.
old drumBOT
Can you share a screenshot of the first row of your spreadsheet? Is that one
fetched correctly?
tiny glacier
yes it is
Does the api call take reference from the first row to determine the data type of the column?
How do I change it such that it takes string values instead of numeric values?
old drumBOT
This seems to be a bug. The workaround would be to use as first row a row that
contains string values in all those fields instead of zeroes.
safe sequoia
cc - @odd sigil
odd sigil
Hi @tiny glacier , could you please let us know what version of Appsmith are you using?
old drumBOT
This fix will be released very soon:
https://github.com/appsmithorg/appsmith/pull/15470
Please check it for more information on the bug and its workaround.
