Release Notes
July 2024
We have changed our sync strategy for the TASK
and TIME_ENTRY
tables and their child tables. Instead of weekly, we now perform a monthly re-import for these tables.
June 2024
Effective June 27, 2024 we use a new June 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.
We have made the following schema changes to avoid data integrity issues.
You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.3 total changes • 3 possible breaking changes
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
ACCESSIBLE_CUSTOM_FIELD | |||||
column | Primary Key Change | list_id | list_id 🔑 | Added to primary key | |
GOAL_GR_0_UP_MEMBER (new table name: GOAL_GROUP_MEMBER) | |||||
table | Rename Table | GOAL_GR_0_UP_MEMBER | GOAL_GROUP_MEMBER | Renamed a Table | |
SUB_TASK | |||||
column | Rename Column | tag | tags | Renamed a column |
March 2024
We have changed the primary key of the GOAL_GROUP_MEMBER_IN_GOAL_FOLDER
table. We now use the index
column as the primary key. Previously, we used the id
column as the primary key. Be sure to update your queries.
November 2023
We have added new lookback windows for the following tables:
- 15 days for the
TIME_ENTRY
table - 1 day for the
SUB_TASK
andTASK
tables.
We have added the following new columns to the SUB_TASK
table:
archived
custom_fields
custom_id
description
folder_id
list_id
priority
project_id
space_id
team_id
text_content
time_spent
url
We have added a new column, point
, to the TASK
table.
We have removed the following columns from the SUB_TASK_ASSIGNEE
table:
color
email
initial
username
We have removed the parent
column from the TASK
table.
April 2023
Lite connectors are now available for the following sources: