Google Sheets - append recipe - date type error

[jereze]

When using the "append recipe" of the Google Sheets plugin, if the input dataset has a column with type "date", a TypeError is raised.

Error in Python process: At line 69: <type 'exceptions.TypeError'>: datetime.datetime(2014, 7, 1, 0, 15, 24, tzinfo=tzoffset(None, 7200)) is not JSON serializable

https://community.dataiku.com/t5/Plugins-Extending-Dataiku-DSS/Can-t-write-with-Google-Sheets-Plugin-JSON-serializsation-with/m-p/6914#M338