data-studio-connector
data-studio-connector copied to clipboard
Data sampling can produce invalid JSON
For dataset: https://data.world/rflprr/google-ds-connector-performance
And query: SELECT * FROM hdx_org
It seems somewhere in return textLines.slice(0, sampleSize).map(JSON.parse); in rest.gs, one of the values has a starting quote but does not end the quote.
Google App's FetchUrl service limits response size to 25Mb. Solving this issue would require:
- Google to extend that limit for data.world, or
- data.world to add support for HTTP range requests, so that the connector could retrieve results in 25Mb chunks