Anyone have problems with creating charts or aggregate functions on imported data? about importjson HOT 4 CLOSED

Solved it. All numerical data were getting transformed to strings unless the noTruncate flag was set.

The fix is to change these lines in the defaultTransform_ function:

if (!hasOption_(options, "noTruncate") && data[row][column]) {
  data[row][column] = data[row][column].toString().substr(0, 256);
}

to

if (!hasOption_(options, "noTruncate") && (typeof data[row][column]=='string')) {
  data[row][column] = data[row][column].toString().substr(0, 256); 
}

from importjson.

Hmm, I'm having the same issue, all numerics are written as text. I tired this code change but that didn't seem to change the behavior of the function. I'm at line 418 in version 1.2.1. Anyone else had luck with this? My work around is computing the =value() of every imported JSON data item.

from importjson.

Hello, converting your data to numbers should take care of this. If you're still experiencing this on the latest version please let me know.

from importjson.

Duplicate of issue #7?

from importjson.