Does not get any data from date fields in Fulcrum

[dunxd]

I have a query which works fine in the CLI to get date and datetime fields. But when I use the same query in the tableau-webdataconnector with the Query API, no data is populated into the column for date time fields. This includes metadata fields such as _created_at as well as fields created with date type.

The SQL query does also return the values correctly when run through the API Docs Try It feature at https://docs.fulcrumapp.com/reference/query-get so I am pretty sure that it is an issue with the tableau-webdataconnector.

[dunxd]

This could be relevant: https://jthiede.wordpress.com/2016/07/24/get-a-working-datetime-format-using-a-tableua-web-data-connector/

I am seeing the issue on a Mac.

[dunxd]

Fulcrum team were unable to replicate. I was able to work around using TO_CHAR(column_name, 'YYYY-MM-DD') AS column_name to get the data into Tableau, and then set the field type to DATE in Tableau.

Hard to say what the underlying cause is, since Fulcrum team were using exactly the same version of Tableau on Mac, and there aren't any settings in Tableau that can be changed by the user.