Release Noteslink
October 2023link
We now re-import the following tables once a week:
USERWORKSPACE_ALLOCATION
August 2023link
We have added the following new columns to the WORKWEEK_MEMBERSHIP and WORKWEEK tables:
created_atupdated_at
We now incrementally sync the following tables:
ACCOUNT_MEMBERSHIPESTIMATEESTIMATE_SCENARIORATE_CARD_HISTORYRATE_CARD_ROLE_HISTORYRATE_CARD_SET_HISTORYRATE_CARD_VERSION_HISTORYROLETIMESHEET_SUBMISSIONUSERWORKWEEKWORKWEEK_MEMBERSHIP
May 2023link
We have added the following new tables:
SKILLSKILL_CATEGORYSKILL_MEMBERSHIP
We are gradually rolling out this change to all existing connectors.
March 2023link
We now support Subscribed Events to capture deletes in a more efficient way. For more information, see our Mavenlink Setup Guide. We are gradually rolling out this change to all existing customers.
February 2023link
We have added a new table, BILLABLE_UTILIZATION. For more information, see Mavenlink's Billable Utilizations documentation. We are gradually rolling out this change to all existing customers.
June 2022link
We now re-sync the following tables to capture deleted records:
WORKSPACE_ALLOCATIONandEXPENSE- once a daySTORY_ALLOCATION_DAYtable - once a week
May 2022link
We now re-sync the WORKSPACE table once a day to detect deleted records.
August 2020link
We have added a new table, TIME_OFF_ENTRY.
May 2020link
You can now configure your Mavenlink connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
September 2019link
We have added two new tables, FIXED_FEE_ITEMS and INVOICE_FIXED_FEE_ITEMS.
March 2019link
- Added
RATE_CARD_VERSION_HISTORYandRATE_CARD_ROLE_HISTORYtables.
February 2019link
- The
ASSIGNMENTtable is re-synced once a day to detect deleted records. - The
RATE_CARDtable is deprecated and will be removed after March 20, 2019. - Added
RATE_CARD_HISTORYto replaceRATE_CARDandRATE_CARD_SET_HISTORYtables.
August 2018link
We have added the column manager_id to the ACCOUNT_MEMBERSHIP table.
Mavenlink does not track deletes for the TIME_ENTRIES table, but Fivetran has a way to identify your deleted time entries. We re-sync the entire TIME_ENTRIES table every day, so our system can infer that any record that wasn’t updated with the re-sync must have been deleted. Each deleted record will be marked as true in the _fivetran_deleted column of this table.
June 2018link
We have added the following tables:
HOLIDAYPARTICIPATIONHOLIDAY_CALENDARHOLIDAY_CALENDAR_ASSOCIATIONSHOLIDAY_CALENDAR_MEMBSHIPWORKSPACE_ALLOCATIONWORKSPACE_RESOURCEWORKWEEKWORKWEEK_MEMBERSHIP
We have added new columns in the following tables:
| TABLE | NEW COLUMN(S) |
|---|---|
| ESTIMATE | updated_at |
| ESTIMATE_SCENARIO | created_at, updated_at |
| ESTIMATE_SCENARIO_RESOURCE | created_at, updated_at |
| RATE_CARD | created_at, updated_at |
| STORY_ALLOCATION_DAY | created_at |
| STORY_STATE_CHANGE | updated_at |
May 2018link
Mavenlink returns choice ID data for custom field types single and multi. We now fetch the choice value instead of the choice ID.
Mavenlink's custom field value type currency contains both cents and currency code data (for example, a currency value of [12,USD] = 12 cents USD). We have split currency data into two columns, <custom_field_name>_amount_in_cents and <custom_field_name>_currency_code.