search

tehhowch / apps-script

A collection of files used by Google Apps Script to develop and serve data via Google Sheets
0 stars 0 forks source link

Add automatic formatPattern interpretation of Fusiontable responses #16

Closed tehhowch closed 5 years ago

tehhowch commented 6 years ago

Rather than leaving the representation to the underlying client library, ensure the returned row data matches the column format specified in the Fusion Tables web UI.

Why? Requests against this: image should not return float or str - they should return int. If we request via alt=media, the bytes response is always str

Review https://developers.google.com/fusiontables/docs/v2/reference/column#resource and implement some auto-parsing. Currently only None and NUMBER_INTEGER are used.

It's possible switching the column to an actual datetime (e.g. DT_ISO_YEAR_MONTH_DAY_TIME) may be useful

tehhowch commented 5 years ago

Closing, since FusionTables are scheduled for turndown.