Due to numerous breaking changes appeared in the new version of the API "2023-10", we were forced to implement a number of changes on our side as well for Monday.com data export.
These changes contain a lot of modifications to names of column type, complexity points amount for queries and limits for requested information size.
Tables rename
Within export you get data of some types as a separate tables.
Next tables were renamed to:
“duration“ to “time-tracking“
“multiple-person“ to “people“
If you already have Tableau export document you can get errors on Refresh.
You can fix it by following next steps:
Open the “Edit connection“
Click “Sign In“ button
After loading of data list of Tables will be updated
Column types renaming
Column Names consist of ‘Name', ‘Type’ and 'Index’ of column.
Due to Types rename a lot of fields changed their names to new ones
Next Types were renamed to:
“color“ to “status“
“boolean“ to “checkbox“
“multiple-person“ to “people“
“timerange“ to “timeline“
“duration“ to “time_tracking“
“numeric“ to “numbers“
“long-text“ to “long_text“
“timezone“ to “world_clock“
Example: If you previously had a column with name “Seller (multiple-person_seller)” - a new name for the same column will be “Seller (people_seller)”
Type “tag“ was renamed to “tags” and currently is not avilable for getting tags list as a string. Now information about tags is available only through additional table "tag" with links to "Tags" (Column of type “tags“ was removed from table “Items“).
Complexity points and limits for requested information size
Changes in complexity points and limits for requested information size might cause export speed slowing down (up to 2x times).
Exported data type changes
Type of fields which contain Identificators (ID) was changed from INT64 to String within export.